Problem 7.

Please provide excel worksheets WITH AND WITHOUT FORMULAS. I will not be able to complete this problem without them. If provided, a thumbs up will be given.

Intro Albatross Inc.'s most recent balance sheet and income statement are given below (all numbers in S million) Assets Cash Accounts receivable Inventory Current assets Net PPE Total assets End of 2020 430 860 1,290 2,580 1,720 4,300 Liabilities and Equity End of 2020 Accounts payable 1,290 Current liabilities 1,290 Long-term debt 2.150 Total liabilities 3,440 Equity 860 Total liab. & equity 4,300 Unit sales were 205.41 million units in 2020, with an average price of $25.12 per unit. Unit sales are expected to grow by 7% per year, while the average price is forecast to grow by only 4% Income statement 2020 5. 160 3,096 172 1,892 Sales Costs Depreciation EBIT Interest Taxable income Taxes Net income Dividends 150.5 1.7415 592 1,149.5 460 Every year, the company spends $200 million on maintaining its capital stock, Since the company is already operating close to capacity, it will have to spend un additional $1 400 million on new machinery in 2021. Depreciation is expected to remain constant at 10.17% of property, plant and equipment (PPE) at the beginning of the year No bond or loan requires repayment until after 2024 Costs, current assets and current liabilities are expected to grow at the same rate as dollar sales, while the tax rate and interest rate will stay constant Part 1 | Attempt 1/10 for 10 pts. Create a spreadsheet to track PPE and depreciation. What will be the book value of net PPE at the end of 2021 (in 5 million)? 0+ decimals Submit - Attempt 1/10 for 10 pts Part 2 What will be net income in 2021 (in 5 million)? 0+ decimals Submit Part 3 - Attempt 1/10 for 10 pts If the company doesn't pay any dividends in 2021, what is the discretionary financing needed (OFN) for 2021 (in 5 million)? 0+ decimals Submit