Pro Forma Income Statement and Balance Sheet

Project description
Using the company’s financial statements (I am using Garmin, Inc.), construct a pro forma income statement and balance sheet for the company using the percentage of sales method.
Be sure to include the original statements along with a defendable sales forcast.
Upon completion of the financials, write a paper detailing the process and what you learned about the company as you work through this activity.
Total deliverable work should be 1 excel spreadsheet AND 1 word document of 500 words.