Question: Please post excel formulas, thank you. Austin Grocers recently reported the following 2019 income statement (in millions of dollars): Sales $700 Operating costs including depreciation
Please post excel formulas, thank you.
Austin Grocers recently reported the following 2019 income statement (in millions of dollars): Sales $700 Operating costs including depreciation 500 EBIT $200 Interest 40 EBT $160 Taxes (25%) 40 Net income $120 Dividends $40 Addition to retained earnings $80 For the coming year, the company is forecasting a 30% increase in sales, and it expects that its year-end operating costs, including depreciation, will equal 65% of sales. Austin's tax rate, interest expense, and dividend payout ratio are all expected to remain constant. a. What is Austin's projected 2020 net income? Enter your answer in millions. For example, an answer of $13,000,000 should be entered as 13. Round your answer to two decimal places. $ million b. What is the expected growth rate in Austin's dividends? Do not round intermediate calculations. Round your answer to two decimal places. %
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
