$1.$ The spreadsheet for PS#$3$ contains balance sheet and income statements from Mergent Online for Apple and Harley$-$Davidson. For each company, estimate the free cash flows using the method from class based on the revenue growth, operating margin, fixed asset turnover, and NWC turnover for years $2023-2027.$ You can use the average of each ratio from the prior $5$ years $($except for the sales growth since you will only be able to average $4$ years$)$ as your estimate of each ratio for each of the next $5$ years.

$2.$ Estimate the WACC from the information given in the spreadsheet.

$3.$ Estimate the price per share with the information given in the spreadsheet. You can assume that after $2027,$ the free cash flows grow forever at $2\%.$ Be sure to label your spreadsheet so that I can follow what you are doing.