Answered step by step
Verified Expert Solution
Question
1 Approved Answer
PLEASE EXPLAIN STEP BY STEP IN DETAIL WHAT TO DO!!! 10. Elena also needs to compare straight-line depreciation amounts with declining balance depreciation amounts to
PLEASE EXPLAIN STEP BY STEP IN DETAIL WHAT TO DO!!!
10. Elena also needs to compare straight-line depreciation amounts with declining balance depreciation amounts to determine which method is more favorable to the company's finances. Go to the Depreciation worksheet. In cell B9, enter a formula using the SLN function to calculate the straight-line depreciation for the new shuttle service during its first year of operation. Use absolute references for the cost, salvage, and life arguments, which are stored in the range B3:B5. Fill the range C9:F9 with the formula in cell B9 to calculate the annual and cumulative straight-line depreciation in Years 2-5. 11. In cell B15, enter a formula using the DB function to calculate the declining balance depreciation for the new shuttle service during its first year of operation. Use Year 1 (cell B14) as the current period. Use absolute references only for the cost, salvage, and life arguments. Fill the range C15:F15 with the formula in cell B15 to calculate the annual and cumulative declining balance depreciation in Years 2-5. 12. Go to the Profit \& Loss worksheet. Elena has entered most of the income and expense data on the worksheet. She estimates revenue will be $825,000 in Year 1 and $1,400,000 in Year 5 of the shuttle service. She needs to calculate revenue for Years 2- 4. Revenue should increase at a constant amount from year to year. Project the revenue for Years 2-4 (cells C7:E7) using a Linear Trend interpolation. Elena also needs to calculate expenses for payroll and rent for Years 2-5. She knows the starting amount for each expense, and estimates the rent in Year 5 will be $64,000. She expects the payroll expenses to increase by at least 6 percent per year and the rent to increase by a constant rate. Project the expenses for Payroll in Years 2-5 (cells C13:F13) using a Growth Trend extrapolation. Use 1.06 (a 6 percent increase) as the step value. Project the expenses for Rent in Years 2-4 (cells C14:E14) using a Growth Trend interpolationStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started