Straight line depreciation in this particular situation

Assignment Help Financial Management

Reference no: EM131819296

It’s five years later and you have replaced your fleet. Now you need to depreciate it for your records. You choose to use declining balance depreciation and assume a 4 year lifespan and a 135% depreciation rate.

Your Excel file should depict the following:

Why might this choice be better than straight line depreciation in this particular situation?

Create a Depreciation Table (similar to Table 7.6 in your Brayley & McLean text) that depicts Period, Starting Book Value, Depreciation Amount, and Remaining Book Value.

Your table should use formulas (multiplication, division, subtraction) that link the cells together so when I make a change to your Starting Book Value in Year 1, I should see changes throughout the entire table.

Reference no: EM131819296

Questions Cloud

What is the amount of current liabilities : The current ratio of a company is 6:1 and its acid-test ratio is 1:1. If inventories and prepaid items amount to $503,000, what is amount of current liabilities

An example of a firm that faced supply chain disruption : Discuss an example of a firm that faced supply chain disruption, and was able to respond to the risk. How successful was the response?

Select two managers of an organization : After discussing business management and strategy, we need to discuss the importance of these topics for the managers and HR department.

Willing to sponsor your new fleet of bikes : You found a company that might be willing to sponsor your new fleet of bikes. They have asked you to send them a proposal.

Straight line depreciation in this particular situation : Why might this choice be better than straight line depreciation in this particular situation?

Calculate the annual turnover-which guarantees the npv : Planned expenditures for the purchase of the land are 1 million Euro, Calculate the annual turnover, which guarantees the NPV at level 0.

What is the amount that should be shown in the ledger : Identifying internal control weakness in cash receipts Red Towne Productions makes all sales on credit. Cash receipts arrive by mail.

Making annual coupon payments and all selling at face value : Consider three bonds with 7% coupon rates, all making annual coupon payments and all selling at face value.

Annual interest compounded quarterly to accomplish goal : What size quarterly deposits does Stan have to make into an account that pays 5.6% annual interest compounded quarterly to accomplish his goal?

User Account

All Pages