Please use the following format and process when preparing and forecasting your financial statements for Starbucks.

1. - Order the columns in rising chronological order i.e. 2014-2015-2016-2017-2018 -2019
2. - Add a column after this with % 2019 vs 2018 (2020 vs 2019 for WMT)
3. - Add a column showing 2015-2019 CAGR (cumulative annual growth rate)
4. - add col 2020 YTD numbers (based on the latest Q numbers: for firms which are not Dec year end))
5. - add col where you show Annualized 2020 YTD
6. - Add 5 cols for 2020 - 2024 and use this for your projections
7. - Add a column after this with % 2020 vs 2019
8. - Add a column showing 2020-2024 CAGR (cumulative annual growth rate)
9. - Your financial statement (IS) should include the following (calculated) rows: Gross Profit $, GP % of Rev, Operating Profit $, OP % of rev, EBIT, EBT, Tax rate % (tax as % of EBT), NI $ and % of sales, EPS ( this is VERY IMPORTANT and needs to calculated base on NI and outstanding shares for your projections). Show Dividend per share (assume previous trend will continue).
10. - Add a worksheet for revenue projections: Show Revenues for each segment / Division and Region for past years (uses same columns as your other Financial Statements) . Use this trend to help project revenues. NOTE: the revenue numbers in your Income statement should be linked to these revenues.
11. - Project the Statement of Shareholder's equity. You may assume similar numbers as 2019 for Dividend and Share buyback projections. The Shareholder's equity section of your balance sheet should be linked to these numbers. Dont project this section of the BS separately, it will be incorrect
12. - BS: keep track of total Curr Assets, Total Assets. Don't increase Goodwill unless you anticipate acquisitions.
13. - Your Fixed assets should grow consistent with prior trend.
14. - Be careful how you handle LT Liabilities as these are borrowings and should be consistent with the information in the Notes section.
15. - To make sure your BS Total ties (Assets = Liab+Equity), you can plug the difference into Cash or ST borrowings (depending on whether the Asset or liabilities side is higher)
16. - Keep misc items flat (ie don't increase or decrease items for no reason)
17. - calculate and add ratios at the bottom of your financial statements (IS and BS) and make sure there are calculated on the worksheet. This way you can see historical ratios and compare it to your projections,
18. - Include all assumptions on the work sheets: you can show this in the same rows or at the bottom of the spreadsheets

Can somebody please format the financial statements for me?