Question

In: Finance

You own a fleet of food trucks. You are thinking about borrowing $2,118,992 for 10 years...

You own a fleet of food trucks. You are thinking about borrowing $2,118,992 for 10 years at 0.05 to upgrade the stove tops in your trucks. This upgrade has an unlevered NPV of 356,960. The terms of this loan require you to add GPS trackers to your trucks, which will cost you $27,539, and $6,408 per year for the next 10 years. Your tax rate is 0.31. You have little use for the GPS trackers, and would not have purchased them if the loan covenants did not require them. What is the NPV of this upgrade if you take take the loan?

Solutions

Expert Solution

Loan amount = 2,118,992

Time of loan = 10 years

Rate = 0.05

Tax rate = 0.31

Unlevered NPV = 356,960

Cost of GPS trackers at Year 0 = 27,539

Per year cost for 10 years cost = 6,408

Incremental costs to be incurred on GPS trackers because of loan = 27,539 + PV of 6,408-10 year Annuity

PV of Annuity Formula = (Payment / R) * (1 - (1+R)-T)

Loan rate will be used for discount rate since that is cost of capital in our case

PV of 6,408-10 year Annuity = (6,408 / 0.05) * (1 - (1+0.05)-10) = 49,480.88

Total Incremental costs on GPS trackers because of loan = 27,539 + 49,480.88 = $ 77,019.9

Now we will find the Tax shield because of loan.

Interest Tax Shield each year = Loan amount * Interest rate * Tax-rate = 2,118,992 * 0.05 * 0.31 = 32,844.38

As the tax shield will remain equal each year, we can calculate its Present value as an annuity at 0.05 discount rate for 10 years

PV of Annuity Formula = (Payment / R) * (1 - (1+R)-T)

PV of Interest Tax-shield = (32844.38 / 0.05)*(1 - (1+0.05)-10) = $ 253,615.6

Incremental NPV after Loan = PV of Interest Tax shield - Incremental costs on GPS trackers after loan

Incremental NPV after loan = 253,615.6 - 77,019.9 = $ 176,595.70

NPV of the upgrade after loan = 356,960 + 176,595.70 = 533,555.70 or $ 533,556

Hence, the Levered NPV of the upgrade is $ 533,556. As Incremental NPV after loan is positive, therefore, Loan should be taken.


Related Solutions

You own a fleet of food trucks. You are thinking about borrowing $2,496,626 for 10 years...
You own a fleet of food trucks. You are thinking about borrowing $2,496,626 for 10 years at 0.06 to upgrade the stove tops in your trucks. This upgrade has an unlevered NPV of 302,555. The terms of this loan require you to add GPS trackers to your trucks, which will cost you $24,608, and $8,642 per year for the next 10 years. Your tax rate is 0.23. You have little use for the GPS trackers, and would not have purchased...
You own a fleet of food trucks. You are thinking about borrowing $2,045,039 for 10 years...
You own a fleet of food trucks. You are thinking about borrowing $2,045,039 for 10 years at 0.06 to upgrade the stove tops in your trucks. This upgrade has an unlevered NPV of 241,095. The terms of this loan require you to add GPS trackers to your trucks, which will cost you $22,949, and $5,793 per year for the next 10 years. Your tax rate is 0.34. You have little use for the GPS trackers, and would not have purchased...
You own a fleet of food trucks. You are thinking about borrowing $2,367,487 for 10 years...
You own a fleet of food trucks. You are thinking about borrowing $2,367,487 for 10 years at 0.07 to upgrade the stove tops in your trucks. This upgrade has an unlevered NPV of 342,464. The terms of this loan require you to add GPS trackers to your trucks, which will cost you $20,414, and $7,903 per year for the next 10 years. Your tax rate is 0.24. You have little use for the GPS trackers, and would not have purchased...
A firm that has zero debt and zero preferred stock is thinking about borrowing money. Their...
A firm that has zero debt and zero preferred stock is thinking about borrowing money. Their capital structure policy allows them a maximum of 40% debt. They currently have a beta of 0.85 and a 35% corporate tax rate. They would like to keep their beta at 1.15 or lower. Can they maximize debt at 40% while meeting their beta goal? Question 1 options: Yes, the levered beta is 1.22 at 40% debt. No, the levered beta is 1.22 at...
You will be graduating in two years and are thinking about your future. You know that...
You will be graduating in two years and are thinking about your future. You know that you will want to buy a house five years after you graduate and that you will want to put down $60,000. As of right now, you have $8,000 in your savings account. You are also fairly certain that once you gradu- ate, you can work in the family business and earn $32,000 a year, with a 5 percent raise every year. You plan to...
Thinking about your own life, are you engaged in a social capital institution? How does being...
Thinking about your own life, are you engaged in a social capital institution? How does being involved in that social capital institution make you more (or less) engaged in civic life? I just need a few points to write an essay on this topic.
For the last 10 years you have been working in the health food business. You have...
For the last 10 years you have been working in the health food business. You have talked to many customers who have suggested a new restaurant concept. The restaurant would feature a variety of low calorie meals (under 500) made from healthy ingredients (organic fruits and vegetables and steroid/hormone free meat). The restaurant would include a bar with an extensive organic wine list and trendy décor. There would be an emphasis on high quality, friendly service, and colorful meal presentation....
For the last 10 years you have been working in the health food business. You have...
For the last 10 years you have been working in the health food business. You have talked to many customers who have suggested a new restaurant concept. The restaurant would feature a variety of low calorie meals (under 500) made from healthy ingredients (organic fruits and vegetables and steroid/hormone free meat). The restaurant would include a bar with an extensive organic wine list and trendy décor. There would be an emphasis on high quality, friendly service, and colorful meal presentation....
For the last 10 years you have been working in the health food business. You have...
For the last 10 years you have been working in the health food business. You have talked to many customers who have suggested a new restaurant concept. The restaurant would feature a variety of low calorie meals ( under 500) made from healthy ingredients ( e.g. organic fruits and vegetables and steroid/hormone free meat). The restaurant would include a bar with an extensive organic wine list and trendy décor. There would be an emphasis on high quality, friendly service, and...
You own a cab company and are evaluating two options to replace your fleet. Either you...
You own a cab company and are evaluating two options to replace your fleet. Either you can take out a​ five-year lease on the replacement cabs for $ 500 $500 per month per​ cab, or you can purchase the cabs outright for $ 30 comma 000 $30,000​, in which case the cabs will last eight years. You must return the cabs to the leasing company at the end of the lease. The leasing company is responsible for all maintenance​ costs,...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT