Question: Please show excel worksheet with and without formulas. I will not be able to complete this problem without the excel worksheets. If excel worksheets are

Intro Rakuten had the following sales in the past: Year 2017 2018 2019 2020 Sales ($ million) 589 555,54 711.59 677.95 Income statement for 2020 Line item Sales - COGS Gross profit SG&A -Depreciation Operating profit - Interest = Taxable income Taxes Net income Amount ($ million) 677.95 271.18 406.77 135.59 67.8 203.39 75 128.39 35.95 92.44 Interest expenses and the average tax rate are expected to stay constant Part 1 JE - Attempt 1/10 for 10 pts. What was the compound (average) annual growth in sales from 2017 to 2020? 4+ decimals Submit Part 2 18 - Attempt 1/10 for 10 pts. Prepare a pro forma income statement for 2021 using the percent-of-sales method. Assume that sales grow at the same rate as in the past. What is the expected net income (not sales)? 0+ decimals Submit
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
