Make a depreciation schedule for a business asset

Assignment Help Financial Management

Reference no: EM13806671

You are asked to make a depreciation schedule for a business asset. A depreciation schedule shows the remaining value of the asset at the end of each time period. Create the following depreciation schedules using Excel. Ensure all calculations are computed with Excel formulas. Place each depreciation schedule on its own individual worksheet.

A $1,200 postage-printing system depreciated using the straight-line method over 4 years with a salvage value of $200. In your depreciation schedule, give the following information for each year: the year’s depreciation, the accumulated depreciation, and the year’s end-of-book value.

Using the same example from part 2, prepare a depreciation schedule using the sum-of-the-year’s digits depreciation method. In your depreciation schedule, give the following information for each year: depreciation rate, year’s depreciation, the accumulated depreciation, and the year’s end-of-book value.

Reference no: EM13806671

Questions Cloud

Transfers cash-net taxable income : Adam transfers cash of $300,000 and land worth $200,000 to Camel Corporation for 100% of the stock in Camel. In the first year of operation, Camel has net taxable income of $70,000. If Camel distributes $50,000 to Adam,

Financial leverage effects-return on invested capital : Firms HL and LL are identical except for their leverage ratios and the interest rates they pay on debt. Each has $30 million in invested capital, has $9 million of EBIT, and is in the 40% federal-plus-state tax bracket. Calculate the return on invest..

Explain time value of money : You've been saving up for a new car that you think costs $25,000. You already have $10,000 and you think that, with interest and additional savings, the $10,000 will grow to $20,000 in three years. What would you do? Assume that the price of the car ..

Duration gap to take advantage of this anticipated rise : If a bank manager was quite certain that interest rates were going to rise within the next 6 months, how should the bank manager adjust the banks duration gap to take advantage of this anticipated rise? What would the manager do if rates were expecte..

Make a depreciation schedule for a business asset : You are asked to make a depreciation schedule for a business asset. A depreciation schedule shows the remaining value of the asset at the end of each time period. Create the following depreciation schedules using Excel. E

Benefit with a fixed rate versus a floating rate swap : How might a financial intermediary or corporation benefit with a "fixed rate" versus a "floating rate" swap?

Two tax topics in mergers and acquisitions : Choose two tax topics in mergers and acquisitions that can put a stop to a deal in a moment’s notice, describe each, and provide how you would prevent them.

What effective annual rate results from daily compounding : What effective annual rate results from daily compounding of 8%? Suppose that you have a mortgage on your house. You make monthly payments. Your bank quotes APR equal 8.5% per year. What is your effective annual rate?

How long will take to double your money with interest rate : How long will it take to double your money with an interest rate of 10 percent? 20 percent? 40 percent? What about tenfold increase in your money with a growth rate of 50 percent? On the advice of your broker ten years ago, you invested in a $6 stock..

User Account

All Pages