please provide answer in excel with formulas

You started your new exiting job as an equity analyst in the invetsment bank. Your team is modelling a financial valuation model fo the IPO for Creative, Inc. You were asked to complete a PPE schedule for the company. Presnted below is the information from the financial statements of the company. Please provide the schedule for PPE and intangible assets. Notes explanations of your approach and assumptions. Especially provide explanations on how you approached Intangible Assets and why. Sales will grow at 7% for the next two years 2018A 2019A 2020A 2021F 2022F Sales 403 162,5 446 371,3 490 354,3 Depreciation and amortization (2 300,0) (3 100,0) (3 400,0) Cash flow investment activities Payments for acquisition of property, plant and equipment (12 913,6) (10 180,2) (7 089,7) Payments for intangible assets 0,0 (700,0) 0,0 Disposals of property, plant and equipment 1 367,0 End of period PPE, NET Goodwill Intangible assets 2017A 56 980,0 500,0 2018A 67 593,6 450,0 50,0 2019A 74 673,8 450,0 700,0 2020A 76 996,5 300,0 560,0 You started your new exiting job as an equity analyst in the invetsment bank. Your team is modelling a financial valuation model fo the IPO for Creative, Inc. You were asked to complete a PPE schedule for the company. Presnted below is the information from the financial statements of the company. Please provide the schedule for PPE and intangible assets. Notes explanations of your approach and assumptions. Especially provide explanations on how you approached Intangible Assets and why. Sales will grow at 7% for the next two years 2018A 2019A 2020A 2021F 2022F Sales 403 162,5 446 371,3 490 354,3 Depreciation and amortization (2 300,0) (3 100,0) (3 400,0) Cash flow investment activities Payments for acquisition of property, plant and equipment (12 913,6) (10 180,2) (7 089,7) Payments for intangible assets 0,0 (700,0) 0,0 Disposals of property, plant and equipment 1 367,0 End of period PPE, NET Goodwill Intangible assets 2017A 56 980,0 500,0 2018A 67 593,6 450,0 50,0 2019A 74 673,8 450,0 700,0 2020A 76 996,5 300,0 560,0