FIN691 Southern New Hampshire University Valuation Problem Set Worksheet Complete Problem 1 in the provided Excel template. Use Excel or save as an Excel f

FIN691 Southern New Hampshire University Valuation Problem Set Worksheet Complete Problem 1 in the provided Excel template. Use Excel or save as an Excel file (.XLS or .XLSX) for all calculations. All formulas should flow through the spreadsheet and entries should not be hard-keyed. Use APA formatting to cite any resources used. Use attachement to complete assignment. Instructions: Fill out the empty cells in the table. Follow the formulas in row H
BASIC TEMPLATE PRO FORMA MODEL
Sales growth
Current assets/Sales
Current liabilities/Sales
Net fixed assets/Sales
Costs of goods sold/Sales
Depreciation rate
Interest rate on debt
Interest paid on cash & marketable securities
Tax rate
Dividend payout ratio
10%
35%
20%
70%
50%
10%
Purchase answer to see full
attachment