Financial Management Project- Balance Sheet,
Need An American Accounting Expert
Business Finance – Accounting
Financial management project- balance sheet, I need an American accounting expert
Graded Project
Financial Management
C o
n t
e n
t s
C o
n t
e n
t s
iii
OBJECTIVE 1
PURPOSE 1
SCORING GUIDELINES 11
G ra
d e
d P
ro je
c t
1
G ra
d e
d P
ro je
c t
1
Financial Management
OBJECTIVE Demonstrate the ability to perform financial calculations and analysis related to the concepts covered in this course.
PURPOSE The purpose of this project is to give you practical experi- ence with financial computations and decision making in the Financial Management field. In this project, you’ll calculate and analyze company balance sheets in the role of a financial manager. Your assignment is to analyze the financial position of the companies mentioned and make recommendations as to the most productive use of their assets and the ideal finan- cial structures for their balance sheets. Show all calculations or calculator inputs for credit. Do all work using equations and a calculator. Do not submit or use an Excel spreadsheet to calculate.
Part 1: Financial Statements and Ratios 1A. You’re the chief financial officer (CFO) of Worldwide Widget Manufacturing, Inc. The company manufactures and sells widgets at factories in the United States and internationally. Listed below are partial financial statements for Worldwide Widget Manufacturing, Inc. Fill in the missing information in each of the following financial statements. Answer spaces are given below.
Graded Project2
Worldwide Widget Manufacturing, Inc. Balance Sheet as of December 31, 2015 and 2014
(in millions of dollars)
2015 2014 2015 2014
Assets Liabilities and Equity Current assets: Current liabilities:
Cash and marketable securities
$ 427 $ 322 Accrued wages and taxes
$ 309 $ 257
Accounts receivable a. ? 259 Accounts payable 381 b. ?
Inventory 815 797 Notes payable $ 492 $ 421
Total $1,542 $1,378 Total $1,182 $997
Fixed assets: Long-term debt: 1,934 c. ?
Gross plant and equipment
d. ? $2,817 Total 3,116 2,956
Less: Depreciation 368 254 Stockholders’ equity:
Net plant and equipment
$2,872 $2,563 Preferred stock (30 million shares)
$ 30 $30
Other long-term assets 521 487 Common stock and paid-in surplus (250 million shares)
300 e. ?
Retained earnings 1,489 1,142
Total FA f. ? $3,050 Total Equity $1,819 $1,472
Total assets $4,935 $4,428 Total liabilities and equity
$4,935 $4,428
a. Accounts receivable for 2015_______
b. Accounts payable for 2014_______
c. Gross plant and equipment for 2015_______
d. Long-term debt for 2014_______
e. Common stock and paid-in surplus (250 million shares) for 2014_______
f. Total FA for 2015_______
3Graded Project 3
Worldwide Widget Manufacturing, Inc. Income Statement for Years Ending December 31, 2015 and 2014
(in millions of dollars)
2015 2014
Net sales g. ? $2,018
Less: Cost of goods sold 753 h. ?
Gross profits $1,623 $1,189
Less: Other operating expenses 423 167
Earnings before interest, taxes, depreciation, and amortization (EBITDA) $1,200 $1,022
Less: Depreciation 114 114
Earnings before interest and taxes (EBIT) $1,086 $ 908
Less: Interest i. ? 128
Earnings before taxes (EBT) $ 949 $ 780
Less: Taxes j. ? 234
Net income $ 664 $ 546
Less: Preferred stock dividends 98 98
Net income available to common stock holders $ 566 $ 448
Less: Common stock dividends 219 199
Addition to retained earnings $ 347 $ 249
Per (common) share data:
Earnings per share (EPS) k. ? $1.79
Dividends per share (DPS) $ 0.88 l. ?
Book value per share (BVPS) m. ? $ 5.77
Market value per share (MVPS) $23.97 $22.47
g. Net sales for 2015_______
h. Less: Cost of goods sold for 2014_______
i. Less: Interest for 2015_______
j. Less: Taxes for 2015_______
k. Earnings per share (EPS) for 2015_______
l. Dividends per share (DPS) for 2014_______
m. Book value per share (BVPS) for 2015_______
Graded Project4
Worldwide Widget Manufacturing, Inc. Statement of Cash Flows for Year Ending December 31, 2015
(in millions of dollars)
Section A. Cash flows from operating activities Net income n. ?
Additions (sources of cash):
Depreciation 114
Increase in accrued wages and taxes o. ?
Increase in accounts payable 62
Subtractions (uses of cash):
Increase in accounts receivable –41
Increase in inventory p. ?
Net cash flow from operating activities q. ?
Section B. Cash flows from investing activities Subtractions:
Increase in fixed assets –$343
Increase in other long-term assets r. ?
Net cash flow from investing activities: s. ?
Section C. Cash flows from financing activities Additions:
Increase in notes payable t. ?
Increase in common and preferred stock 0
Subtractions:
Decrease in long-term debt –25
Pay dividends u. ?
Net cash flow from financing activities: v. ?
Section D. Net change in cash and marketable securities $105
n. Net income_______
o. Increase in accrued wages and taxes_______
p. Increase in inventory_______
q. Net cash flow from operating activities_______
r. Increase in other long-term assets_______
s. Net cash flow from investing activities_______
t. Increase in notes payable_______
u. Pay dividends_______
v. Net cash flow from financing activities_______
5Graded Project 5
Worldwide Widget Manufacturing, Inc. Statement of Retained Earnings as of December 31, 2015
(in millions of dollars)
Balance of retained earnings, December 31, 2014 $1,142
Plus: Net income for 2015 w. ?
Preferred stock x. ?
Common stock 219
Total cash dividends paid 317
Balance of retained earnings, December 31, 2015 $1,489
w. Plus: Net income for 2015 _______
x. Preferred stock _______
1B. For each of the items listed below, indicate on which of the major statements they would be found (1, 2, 3 or 4) and the amount shown on the statements above:
1. Balance sheet 3. Statement of cash flows
2. Income statement 4. Statement of retained earnings
1. Earnings before taxes for 2015_______; $_______
2. Gross plant and equipment for 2015 _______; $_______
3. Increase in fixed assets, December 31, 2015 _______; $_______
4. Net sales for 2015 _______; $_______
5. Balance of retained earnings, December 31, 2015 _______; $_______
6. Common stock and paid-in surplus for 2014 _______; $_______
7. Net cash flow from investing activities, December 31, 2015 _______; $_______
8. Increase in inventory, December 31, 2015 _______; $_______
9. Accrued wages and taxes for 2014 _______; $_______
10. Book value per share (BVPS) for 2015 _______; $_______
2. You’ll need to compare your company’s ratios with the industry’s standards.
Graded Project6
Worldwide Widget Manufacturing, Inc.
Company Industry Comparison
Current ratio 2.2 times
Quick ratio 1.1 times
Cash ratio 0.35 times
Inventory turnover 2 times or 1 time
Days’ sales in inventory 135 days or 335 days
Average payment period 110 days
Sales to working capital 3 times
Total asset turnover 0.6 times
Debt-to-equity 1.1 times
Profit margin 16.5%
Gross profit margin 48.13%
ROA 8.78%
ROE 19.45%
Dividend payout 32%
A. Use the information found in Worldwide Widget Manufacturing’s financial state- ments to calculate all of the listed financial ratios in the above table for your company. Then, for each ratio, provide a comparison of the company’s result with the industry standards, indicating if your company’s results are lower than, higher than, slower than, or faster than the industry standards.
B. Calculate your company’s internal and sustainable growth rates.
Part 2: The Value of Money, Bonds and Stocks 3. The company you work for is looking to expand. As the CFO, you’re tasked with
comparing the cost of buying manufacturing equipment now, at a $250,000 dis- count from its original price of $1,650,000 and storing it for a year, or waiting one year to buy it. The cost of buying the equipment includes the supplier’s bill and the cost to store the item, for a total of $1,464,000. What interest rate is implied by a $1,464,000 cash flow today, versus $1,650,000 in a year? When it comes to obtaining the cash for the purchase of the equipment, what is your rec- ommendation on whether the company should purchase the equipment now or wait a year?
7Graded Project 7
4. Worldwide Widget Manufacturing, Inc., decided to go ahead with its plan to expand. It issued $30 million in debt due in 30 years to finance the expansion at an 8 percent coupon rate. The company makes interest-only, semiannual pay- ments of $1,200,000 on this debt. Debt issued today would cost only 7 percent interest. You have been asked to determine whether the company should issue new debt (for 25 years) to pay off the old debt. If the company does so, it will have to pay $1.7 million as a “call premium” to the existing debt holders, and also $1.4 million to its investment bankers to float the issue. If the new debt was issued, what would be the semiannual interest payment savings or cost? What is the cost to refinance the debt? What would be the present value of the semiannual savings in interest payments over the life of the debt? Should you advise the company to replace the old debt with new debt? Why?
5. Worldwide Widget Manufacturing, Inc., is doing so well it decides it’s time to become an international company. As the chief financial officer (CFO), you’re tasked with raising $340 million of new capital to open offices around the world. In researching the matter, you learn that if bonds due in 20 years are used for raising the capital, they’ll be rated AA and will need to offer a yield of 6.5 percent. How many bonds will it be necessary to issue to raise the needed capital? What will Worldwide Widget Manufacturing have to make as a semiannual interest rate payment?
Part 3: Stock Returns 6. Worldwide Widget Manufacturing, Inc., has decided to invest in some stock. As
CFO, you’ve been asked to review the portfolio. First, you’ll need to measure the past performance of the investments. Then, measure the past return’s risk of the investment. Lastly, calculate the average return and risk of the portfolio.
The following table shows the annual returns for Company A and Company B, which are part of the investment portfolio you’re interested in.
Company A Company B
Year 1 5.23% 13.51%
Year 2 8.91 -9.35
Year 3 7.32 2.44
Year 4 -15.81 3.12
Year 5 -8.32 14.81
Year 6 25.98 18.36
Graded Project8
What’s the average return and standard deviation of returns for these two companies? What’s the average return and standard deviation of returns for the portfolio? What’s the average return of a portfolio consisting of 60 percent of Company A and 40 percent of Company B?
7. After coming to a final decision, Worldwide Widget Manufacturing, Inc., has a stock portfolio that consists of the following positions, with betas shown for each stock. You’ve been asked to calculate and evaluate the risk of the portfolio beta and the required return for your portfolio. The market return is expected to be 11 percent, and the risk-free rate is 6 percent.
Shares Price Position Weight Beta W x Beta Merck & Co., Inc. 150 61 ? ? 1.62 ?
Domino’s Pizza 200 152 ? ? 1.8 ?
Macy’s, Inc. 300 36 ? ? 1.42 ?
Tesla 150 202 ? ? 2.51 ?
Totals ? 1 ? ?
What’s the beta of the portfolio? Is this a high- or low-risk portfolio? What’s the required return of the portfolio? Fill in the position, weight, and portfolio beta columns for each company in the table above. Show calculation.
A. Merck & Co., Inc.
1. Position:
2. Weight:
3. W × Beta:
B. Domino’s Pizza
1. Position:
2. Weight:
3. W × Beta:
C. Macy’s, Inc.
1. Position:
2. Weight:
3. W × Beta:
D. Tesla
1. Position:
2. Weight:
3. W × Beta:
Total Position:
Total W × Beta:
Expected Return:
The risk of the portfolio:
9Graded Project 9
Part 4: Capital Budgeting 8. Worldwide Widget Manufacturing, Inc., is preparing to launch a new manufactur-
ing facility in a new location. The company has a capital structure that consists of debt and common and preferred stock. The company is considering changing this capital structure in conjunction with the launch of the new manufacturing facility. The manufacturing facility project is slated to be funded with 30 per- cent debt, 30 percent preferred stock, and 40 percent common stock. Worldwide Widget Manufacturing has 15 million shares of common stock outstanding. The shares sell at $24.63 per share. The company expects to pay an annual dividend of $1.50 one year from now, after which future dividends are expected to grow at a constant 7 percent rate. Worldwide Widget Manufacturing’s debt consists of 30-year, 9-percent annual coupon bonds with a face value of $180 million and a market value of $185 million. The company’s capital mix also includes 200,000 shares of 12-percent preferred stock trading at par. If Worldwide Widget Manufacturing has a marginal tax rate of 32 percent, what weighted average cost of capital (WACC) should it use as it evaluates this project?
9. Worldwide Widget Manufacturing, Inc., wants to add two new production lines of widgets. You’re asked to analyze whether to go forward with two mutually exclu- sive projects. The cash flows of both projects are displayed below. Your company uses a cost of capital of 9 percent to evaluate projects such as the two you’re now analyzing. Show all calculations.
Year: 0 1 2 3 4 5
Project A Cash Flow –$1,000 $150 $300 $500 $300 $250
Project B Cash Flow –$1,400 $300 $470 $200 $600 $350
Calculate the payback of Project A:
Calculate the payback of Project B:
Calculate the IRR of Project A:
Calculate the IRR of Project B:
Using the NPV method and assuming a cost of capital of 6 percent, calculate the NPV of these two projects. Which of these mutually exclusive projects should the company accept?
Graded Project10
Part 5: Forecasting and Capital Structure 10. You’ve been asked to use the following historical sales information to forecast
next year’s sales for Worldwide Widget Manufacturing, Inc. The actual sales for 2016 were $1,950,000.
Year: 2011 2012 2013 2014 2015
Sales $1,750,000 $2,000,000 $1,350,000 $2,250,000 $1,800,000
What would be next year’s forecast using the naïve approach and the average sales approach? What would be the MAPE using the naïve approach and the average sales approach?
11. After adding a new line of widgets, Worldwide Widget Manufacturing, Inc., expects all assets and current liabilities to shrink with sales. The company has sales for the year just ended of $20 million. The company also has a profit margin of 20 percent, a return ratio of 25 percent, and expected sales of $18 million next year. Worldwide Widget Manufacturing, Inc., shows the following on its balance sheet.
Assets Liabilities and Equity
Current assets $2,500,000 Current liabilities $1,250,000
Fixed assets $3,500,000 Long-term debt $1,500,000
Equity $3,250,000
Total assets $6,000,000 Total liabilities and equity $6,000,000
What amount of additional funds (AFN) will Worldwide Widget Manufacturing, Inc., need from external sources to fund the expected growth? What does the AFN show?
11Graded Project 11
SCORING GUIDELINES Your project will be graded according to the criteria found in the rubric below. Your point total will be divided by the total number of points available for the project (200).
Rubric:
Skill/ Grading Criteria
All calcu- lations,
equations, and expla- nations are
correct.
Most cal- culations, equations, and expla- nations are
correct.
Some cal- culations, equations, and expla- nations are
correct.
Few or no calcu- lations,
equations, and expla- nations are
correct.
Grader’s Comments
Part 1:
Question 1 Worth a Total of
30 Points
30–22 21–15 14–7 6–0
Question 2 Worth a
Total of 30 Points
30–22 21–15 14–7 6–0
Part 2:
Question 3 Worth a
Total of 10 Points
10–7 6–4 3–1 1–0
Question 4 Worth a
Total of 10 Points
10–7 6–4 3–1 1–0
Question 5 Worth a
Total of 10 Points
10–7 6–4 3–1 1–0
(Continued)
Graded Project12
Part 3:
Question 6 Worth a
Total of 30 Points
30–22 21–15 14–7 6–0
Question 7 Worth a
Total of 20 Points
20–15 14–10 9–5 4–0
Part 4:
Question 8 Worth a
Total of 20 Points
20–15 14–10 9–5 4–0
Question 9 Worth a
Total of 20 Points
20–15 14–10 9–5 4–0
Part 5:
Question 10 Worth a
Total of 10 Points
10–7 6–4 3–1 1–0
Question 11 Worth a
Total of 10 Points
10–7 6–4 3–1 1–0
Total Points
Total Score
_____/200
13Graded Project 13
Submitting Your Project Each project is individually graded and therefore could take approximately 5–7 business days to grade.
Follow this procedure to submit your assignment online:
Make sure the following information is in the heading of each document:
n Your name
n Your email address
n Your student number
n Course name and number
n Project number (081776)
1. Go to http://www.pennfoster.edu and log in to your stu- dent portal.
2. On your student portal, click on Take an Exam.
3. In the box provided, enter the examination number. The number for this exam is 081776.
4. Click on Submit.
5. On the next screen, enter your email address. (Note: This information is required for online submission.)
6. If you wish to tell your instructor anything specific regarding this assignment, enter it in the Comments.
7. Attach your file or files as follows:
a. Click on the first Browse box.
b. Locate the file you wish to attach.
c. Double-click on the file.
d. To attach the additional files, click on the next Browse box and repeat steps b and c. Repeat until all files are uploaded.
8. Click on Submit.