Question: 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!!!

PLEASE EXPLAIN STEP BY STEP IN DETAIL WHAT TO DO!!! 10. Elena

also needs to compare straight-line depreciation amounts with declining balance depreciation amountsto determine which method is more favorable to the company's finances. Goto the Depreciation worksheet. In cell B9, enter a formula using theSLN function to calculate the straight-line depreciation for the new shuttle service

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 interpolation

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!