50.1K

Verified Solution

Link Copied!

6. In the range B7:F7, project the company's income and expenses for the next five years by interpolating the Year 2 through Year 4 revenue assuming a growth trend. 7. In the range B8:F8, use the Percent Cost of Sales and Marketing (cell F2) to calculate the Year 1 through Year 5 Cost of Sales and Marketing. (HINT: just a simple formula) 8. In the range B9:F9, use the Percent Cost of Research and Development (cell F3) to calculate the Year 1 through Year 5 Cost of Research and Development. (HINT: just a simple formula) 9. In the range B10:F10, calculate the gross profit by subtracting the cost of Sales and Marketing and Research and Development from the annual projected sales. 10. In the range B13:F13, extrapolate the Year 2 though Year 5 Payroll expenses by assuming the payroll grows by 15 percent each year. In B14:F14 extrapolate the other expenses by assuming they grow by 7% per year from the initial year 1 values. 11. In the range B18:F18, calculate the Total General Expenses for Years 1 through 5. 12. In the range B21:F21, calculate the company's Initial Earnings for each year, equal to the Gross Profit minus the Total General Expenses. (The Depreciation in row 22 will be calculated later.) 13. Switch to the Depreciation Sheet. 14. In the range B9:F9, calculate the Yearly straight-line depreciation of the long-term assets using the SLN function in the range 10-F10 calculate the cumulative repreciation through the first five years. In the Forn nglish (United States) 6. In the range B7:F7, project the company's income and expenses for the next five years by interpolating the Year 2 through Year 4 revenue assuming a growth trend. 7. In the range B8:F8, use the Percent Cost of Sales and Marketing (cell F2) to calculate the Year 1 through Year 5 Cost of Sales and Marketing. (HINT: just a simple formula) 8. In the range B9:F9, use the Percent Cost of Research and Development (cell F3) to calculate the Year 1 through Year 5 Cost of Research and Development. (HINT: just a simple formula) 9. In the range B10:F10, calculate the gross profit by subtracting the cost of Sales and Marketing and Research and Development from the annual projected sales. 10. In the range B13:F13, extrapolate the Year 2 though Year 5 Payroll expenses by assuming the payroll grows by 15 percent each year. In B14:F14 extrapolate the other expenses by assuming they grow by 7% per year from the initial year 1 values. 11. In the range B18:F18, calculate the Total General Expenses for Years 1 through 5. 12. In the range B21:F21, calculate the company's Initial Earnings for each year, equal to the Gross Profit minus the Total General Expenses. (The Depreciation in row 22 will be calculated later.) 13. Switch to the Depreciation Sheet. 14. In the range B9:F9, calculate the Yearly straight-line depreciation of the long-term assets using the SLN function in the range 10-F10 calculate the cumulative repreciation through the first five years. In the Forn nglish (United States)

Answer & Explanation Solved by verified expert

See Answer