Question

Please show work, step by step, no excel. Thank you! (MACRS depreciation) Henebry Boat Rentals has...

Please show work, step by step, no excel. Thank you!

(MACRS depreciation) Henebry Boat Rentals has purchased several for a total of $150,00. They are classed as five-year property.

  1. What is the annual depreciation charge for these assets?
  2. If the firm’s marginal tax rate is 40%, what is the annual depreciation tax shield?
  3. Discounted at 8%, what is the present value of the depreciation tax shield?

Homework Answers

Answer #1

A.

Year MACR RATE Depreciation $ (MACR*15000)
1 0.2 3000
2 0.32 4800
3 0.192 2880
4 0.1152 1728
5 0.1152 1728
6 0.0576 864

B.

Year Depreciation Tax rate Tax shield
1 3000 0.4 1200.0
2 4800 0.4 1920.0
3 2880 0.4 1152.0
4 1728 0.4 691.2
5 1728 0.4 691.2
6 864 0.4 345.6

C.

Year Tax shield PVF @ 8% PV $
1 1200.0 0.925925926 1111.11
2 1920.0 0.85733882 1646.09
3 1152.0 0.793832241 914.49
4 691.2 0.735029853 508.05
5 691.2 0.680583197 470.42
6 345.6 0.630169627 217.79
TOTAL 4867.95
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Please show work step by step, and no excel. Thank you! (Basic capital budgeting) An investment...
Please show work step by step, and no excel. Thank you! (Basic capital budgeting) An investment of $30,000 will be depreciated straight line for 10 years down to a zero salvage value. For its 10 year life, the investment will generate annual sales of $12,000 and annual cash operating expenses of $2,000. Although the investment is depreciated to a zero book value, it should sell for $3,000 in 10 years. The marginal income tax rate is 40% and the cost...
Please show work step by step, no excel. Thank you! A machine that costs $10,000 new...
Please show work step by step, no excel. Thank you! A machine that costs $10,000 new can be replaced after being used from four to seven years. Annual maintenance costs are identical for all possible replacement cycles. The machine has a cost of capital of 12%. The alternative net salvage values at the end of four to seven years of use are, respectively, $3,800, $2,800, $1,000, and -$1,000. Ignoring taxes and inflation, what is the optimal replacement cycle?
Please show work step by step, NO EXCEL. Thank you! A2. (Recognize puts and calls) Indicate...
Please show work step by step, NO EXCEL. Thank you! A2. (Recognize puts and calls) Indicate whether the stock price, strike price, and exercise value given here are for a call option or a put option. stock price strike price exercise value type of option put or call? $65 $60 $0 25 20 5 15 30 15 97 105 0
Please include an Excel step by step process. Thank you Big Sky Hospital plans to obtain...
Please include an Excel step by step process. Thank you Big Sky Hospital plans to obtain a new MRI that costs $1.5 million and has an estimated four-year useful life. It can obtain a bank loan for the entire amount and buy the MRI, or it can obtain a guideline lease for the equipment. Assume that the following facts apply to the decision: - The MRI falls into the three-year class for tax depreciation, so the MACRS allowances are 0.33,...
Please show work, thank you in advance :) What is the present value of a semi-annual...
Please show work, thank you in advance :) What is the present value of a semi-annual ordinary annuity payment of $7,000 made for 12 years with a required annual return of 5%? $ 65,145 $128,325 $125,195 (correct) $ 62,043 You deposit $10,000 in a bank and plan to keep it there for five years. The bank pays 8% annual interest compounded continuously. Calculate the future value at the end of five years. $14,693 $15,000 $14,918 (correct) $14,500 What is the...
Please solve this for me step by step (no excel, no financial cal. show algebra)? Thank...
Please solve this for me step by step (no excel, no financial cal. show algebra)? Thank you. You put 100,000 into a money market instrument September 4 2018 for six calendar months at 3%. When it matures, you roll it over for the next six months at 4%. What are the proceeds? Be careful with the day counts. What would need to be the (“equivalent”) rate on a one-year (i.e., non-money market) semi-annual compounding instrument in order to produce the...
Show work through excel using formulas: but please actually show each step you use to do...
Show work through excel using formulas: but please actually show each step you use to do it on excel! 1. Assume you have taken out a balloon mortgage loan for $2,500,000 to finance the purchase of a commercial property. The loan has a term of 5 years, but amortizes over 25 years. Calculate the balloon payment at maturity (Year 5) if the interest rate on this loan is 4.5%. A. $5,637.99 B. $13, 895.82 C. $2,196,447.59 D. $2,495,479.19
ONLY COMPLETE USING EXCEL SHOWING WORK - THANK YOU! An office building is purchased with the...
ONLY COMPLETE USING EXCEL SHOWING WORK - THANK YOU! An office building is purchased with the following projected cash flows: • NOI is expected to be $130,000 in year 1 with 5 percent annual increases. • The purchase price of the property is $720,000. • 100 percent equity financing is used to purchase the property. • The property is sold at the end of year 4 for $860,000 with selling costs of 4 percent. • The required unlevered rate of...
PLEASE SHOW WORK AND NO EXCEL! THANK YOU A deposit of $800,000 is made in February...
PLEASE SHOW WORK AND NO EXCEL! THANK YOU A deposit of $800,000 is made in February 25, 2011. By what date the deposit will be worth $1.2M at 12% compounded annually? What would be the answer if interest was compounded daily? (Use 1 year=360 days.) Why does this date come earlier?
Please solve in Excel format and show step-by-step formulas Not wanting to leave his beloved alma...
Please solve in Excel format and show step-by-step formulas Not wanting to leave his beloved alma mater, Will Anderson has come up with a scheme to stay around for 5 more years: He has decided to bid on the fast-food concession rights at the football stadium. He feels sure that a bid of $30,000 will win the concession, which gives him the right to sell food at football games for the next 5 years. He estimates that annual operating costs...