accounting homework help

/in /by

EXCEL
Excel submission is required, other file formats are not accepted!
attachment
FI305 – Fall 2020 Final Exam Part II
This part of the exam has 4 problems with 50 available points in total. You will submit the exam via Blackboard in an Excel spreadsheet. (DOC, PDF or other formats are not accepted). Your own work is required, and group work is not allowed. Good luck!
Problem 1: (15 Points)
Consider Gavin, a new freshman who has just received a student loan and started college. He plans to obtain the maximum loan from at the beginning of each year. Although Gavin does not have to make any payments while he is in school, the 6.8 percent interest owed (compounded monthly) accrues and is added to the balance of the loan. After graduation, Gavin gets a six-month grace period. This means that monthly payments are still not required, but interest is still accruing. After the grace period, the standard repayment plan is to amortize the debt using monthly payments for 10 years.
Loan Limits:
Freshman $6,000
Sophomore $6,000
Junior $7,000
Senior $7,000
a. Construct cash flows of the loan.
b. What will be the loan balance when Gavin graduates after his fourth year of school?
c. What is the loan balance six months after graduation?
d. Using the standard repayment plan and a 6.8 percent APR interest rate, compute the monthly payments Gavin owes after the grace period.
Problem 2: (10 points)
You are a financial manager at a soft-drink company. Until today the company bought empty cans from an outside supplier. You are considering whether to purchase a machine and begin manufacturing cans in-house to achieve cost savings.
The cost of purchasing a can machine is $850,000 and the lifespan of the machine is 8 years. At the end of 8 years, the company expects to sell the machine for $120,000. Assume the machine is depreciated each year at $95,000 per year.
The cost savings generated by the can machine will be $160,000 per year.
Assume that the project requires an investment in Net Working Capital (NWC) of $20,000, and none of this is recovered at the end of the project.
The machine would be purchased at year 0, the NWC investment occurs at year 0, and all subsequent cash flows occur in years 1-8.
Assume the discount rate is 10% and the corporate tax rate is 21%.
Determine the NPV of purchasing the can machine. Should you accept or reject the project?
Problem 3: (15 Points)
Calculate weighted average cost of capital (WACC) for Starbucks Corporation (Ticker:SBUX).
Use Capital Asset Pricing Model in your analysis for cost of common stock estimate and calculate Beta based on last five year’s monthly adjusted close prices. Use S&P returns in your market estimate. You can obtain historical prices on Yahoo Finance.
Use 10-year US Treasury Bond yield as your risk-free rate (Use the yield on 12/10/2020) and assume the market return as 8%.
Calculate total number of shares based on total market capitalization and market price on 12/10/2020. Use the market value of common stock in your calculation.
Assume Starbucks preferred stock market price as 180 $ and outstanding number of preferred stocks as 250.000.000. Preferred dividend of Starbucks is 7$.
Assume Starbucks only has long term debt and use the value of debt on the balance sheet for the end of 09/30/2020. Find the interest expense for the same period and use the average interest rate as your cost of debt.
Use effective tax rate based on tax expense and taxable income on 09/30/2020 income statement.
Problem 4: (10 Points)
You are tasked with estimating the value of a stock. Specifically, estimate the common stock’s per-share value using the free cash flow model. Use the following assumptions to perform your computation:
You project EBIT to be $3,000,000 next year.
Their depreciation expense will be $900,000 next year. Their tax rate is 25%.
You project their capital expenditures to be $395,000.
They currently have $210,000 in cash, and they do not have any debt.
They have preferred stock, which is valued at $1,500,000. The change in net working capital is $500,000.
You calculate their WACC (discount rate) to be 8% and estimate that free cash flows will grow by 4% a year.
The company has 750,000 common shares outstanding.
If this stock is currently trading at $80 per share, would you recommend buying it? Provide a brief explanation for your recommendation.