I need help understanding the work I did already and explaining how to conduct a pro-forma financial statement for Amazon.

I have already completed the ratios for the three years for Amazon. I need to be able to analyze what the ratios tell me about Amazon over the last three years.

The alternative strategies I am going to come up with and it will be centered on Amazon utilizing the new partnership with Whole Foods to do home delivery food on a larger scale. So they would have to invest in more resources, however they would hopefully receive more profits as a result of taking some of the market from hellofresh and blue apron.

The area I need the most help with is as follows.

1.Pro-Forma Financial Statements (I/S, B/S and Statement of Cash Flows) with deltas out 3 years and analysis

Each year must have 2 columns: 1 with your strategy and 1 without your strategy.

a.Include Pro-Forma ratios for the first year out with deltas contrasting from the most current year's ratios.

Net Present Value analysis of proposed s

** I have already completed the last three historical data and formatted my spreadsheet to account for a strategy. I need help understanding the increases I would put and how to conduct a proforma financial statement. I need help understanding the way to incorporating the strategy of expansion for Amazon. They have experienced high growth the last year and I think it will continue.

On the spreadsheet the "my strategy" is with my strategy.

The without my strategy is what would be the standard prediction of the market if Amazon did not change anything.

Thank you so much. I need this asap, so I am providing a higher amount of money. I have completed a large portion already.

Highlights of what I need.

1. Analysis of the ratios I calculated in the spreadsheet. Like what do they tell me about the performance or future
2. Proforma financial statements for Amazon over the next three years based on my strategy and based on current marketplace. I already have the "Delta" columns formatted to just calculate based upon numbers being inputted. I also attached an example of what someone else used for increasings and percentages but I am not sure how valid they are. My spreadsheet is matt avery homework help.

Thank you.