Excel sheet attached –*****You will be using the same data and template as was used in Homework Assignment 3 so there should be no need to reenter the company’s financial statement data. In addition, you may want to download a copy of the review problem that highlights some aspects of how to complete the assignment. In addition, you may also want to download a copy of the review problem that provides a solution to a similarly-worded problem. When completed with the assignment, which should be completed in Excel or similar spreadsheet format****
Using the financial statement data for Advanced Micro Devices provided , along with the following assumptions, prepare a forecasted income statement, balance sheet, and statement of cash flows for the company for 2019. Be certain to incorporate the impact that the additional debt and resulting increase in interest expense would have on your pro forma financial statements (i.e., include the results of at least the first feedback loop). In addition, be certain that the forecasted income statement, balance sheet, and statement of cash flow data fully articulate (e.g., the projected change in cash on the cash flow statement equals the projected change in cash shown on the projected balance sheet).