Leave percentages with 1 decimal point. For the Proformas, you can leave as whole dollars. For the TMV and NPV problems, round to the nearest penny. Cells collored yellow are to be solved and cells colored green are to be filled in with information provided in the question You must show the excel formulas, not just the typed in value.

Financial Analysis- Common-Size and Common-Base Year Financial Statements Construct the common-size balance sheet and common-base year balance sheet for the company. Use 2020 as the base year