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

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 provided, I will give a thumbs up.  Please show excel worksheet with and without formulas. I will not
be able to complete this problem without the excel worksheets. If excel

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!