Question
Can you please provide the excel formulas to answer the questions below? Here is the information from a previous question asked in Chegg, but I
Can you please provide the excel formulas to answer the questions below? Here is the information from a previous question asked in Chegg, but I am having trouble understanding how this information was found. Can you use data and excel equations to provide how the explanation to build come size income statements for 2016,2017 and 2018 was found?
Estimate the free cash flow of 2019 under the following assumptions. Assumptions: 1. Year 2019 sales projection: $31,556,000,000 2. All the other income statement accounts are assumed to hold a constant percentage as sales. The percentage is the average percentage of fiscal years 2016, 2017 and 2018. 3. Investment in net operating working capital and capital expenditure are assumed to stay perpetually as the average of year 2017 and 2018. Requirements: 1. Build common size income statements for year 2016, 2017 and 2018. 2. Prepare a pro forma income statement for year 2019.
Explanation: ==> 1. Build common size income statements for year 2016, 2017 and 2018: - Income StatementStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started