Using the attached data, which represents five years of actual results of a publicly traded company, please create a dynamic financial model. The financial model should include a P&L, Balance Sheet, and Cash Flow statement for Years 1 through 5, as well as project out Years 6 through 8. The financial model should allow for dynamic adjustment of business case assumptions.
See file for Data
Instructions This exercise is two-part in nature: 1) Using the attached data, which represents five years of actual results of a publicly traded company, please create a dynamic financial model. The financial model should include a P&L, Balance Sheet, and Cash Flow statement for Years 1 through 5, as well as project out Years 6 through 8. The financial model should allow for dynamic adjustment of business case assumptions. 2) Based upon your analysis, what insights can you derive about the business? Please include a summary of meaningful business metrics and a brief (~1 page) narrative explaining what you observed, what key assumptions you made, and how you used those to determine your findings. Data $ 000'sActuals Year 1Year 2Year 3Year 4Year 5 Product Revenue$ 1,344$ 1,280$ 1,280$ 1,346$ 1,370 Service Revenue- 0123137169215 Total Revenue1,3441,4021,4181,5151,585 Cost of Products Sold500433434444462 Cost of Services Provided- 053587798 Cost of Goods Sold500486491522560 SG&A616624640680691 Interest Expense4644484738 Cash16 A/R6666697088 Inventory2222222329 Other Current Assets2719627170 PP&E457459466463462 Accumulated Depreciation(335)(338)(353)(359)(361) Accounts Payable6160656571 Accrued Expenses9294879695 Other Current Liabilities4150635151 Long Term Debt743748656657400