Question

In: Finance

Acme has branched out to rentals of office furniture to start-up companies. Consider a $4,100 desk....

Acme has branched out to rentals of office furniture to start-up companies. Consider a $4,100 desk. Desks last for six years and can be depreciated immediately. Assume that lease rates for old and new desks are the same and that Acme’s pretax administrative costs are $310 per desk at the beginning of each year. The cost of capital is 12% and the tax rate is 21%. Lease payments are made in advance, that is, at the start of each year. The inflation rate is zero. Suppose a blue-chip company requests a six-year financial lease for a $4,100 desk. The company has just issued five-year notes at an interest rate of 9% per year. What is the break-even rate in this case? (Do not round intermediate calculations. Round your answer to 2 decimal places.)

PLEASE PROVIDE EXCEL SHEET WITH EXPLANATION

Expert Solution

Step 1:

Lets find the Net Present Value of all cash-flows except the lease rental:

Notes:

1. Cost of $4,100 = given in question

2. Desk to be depreciated immediately. Hence full depreciation for desk value $4,100 to be taken in Year 0. Tax shield of 21% on $4,100 for $861 to be considered as cash-inflow in year 0

3. Administrative costs = $310

Post tax administrative costs = $310*(100%-21%) = $245. These are incurred at the beginning of each year , hence from Year 0 to Year 5.

4. Annual cash flow = Cost + Post tax administrative costs - Tax shield on Depreciation

5. Discount factor at 12% =

Year 1 = 1/(1+12%)^1 = 0.893

Year 2 = 1/(1+12%)^2 = 0.797

Year 3 = 1/(1+12%)^3 = 0.712

Year 4 = 1/(1+12%)^4 = 0.636

Year 5 = 1/(1+12%)^5 = 0.567

6. Present Value of Annual Cash-flow = Annual cash flow * Discount factor at 12%

Working:

Step 2: Break even rate

Annual leases are made in advance. Hence lease payments will be received from Year 0, Year 1 to Year 5.

To have break-even rate, the present value of after tax annual leases of 5 years at 12% should equal $4,366.71.

Let Annual lease payment be X. Tax rate is 21%. Hence after tax annual lease = X*(100%-21%) = X*79% = 0.79X

Cumulative discount factor for 5 years at 12% discount rate = ((1-(1+12%)^-5))/12% = 3.60478

Thus, the present value of after tax annual leases of 5 years at 12% = 0.79X * 3.60478 = 2.84777X

Annual lease paid at year 0 = 0.79X*1 = 0.79X

Hence, 2.84777X+0.79X = 4,366.71 =

3.63777X = 4,366.71=

X = 4,366.71/3.63777 = $1,200.38

Thus, the break-even rate is $1,200.38

jeff jeffy answered 2 years ago

Acme has branched out to rentals of office furniture to start-up companies. Consider a $5,000 desk....

Acme has branched out to rentals of office furniture to start-up companies. Consider a $5,000 desk. Desks last for six years and can be depreciated on a five-year MACRS schedule. Assume that lease rates for old and new desks are the same and that Acme’s pretax administrative costs are $800 per desk at the beginning of each year. The cost of capital is 9% and the tax rate is 35%. Lease payments are made in advance, that is, at the...

The ACME company has purchased some office furniture costing $13,500 and is expected to have a...

The ACME company has purchased some office furniture costing $13,500 and is expected to have a salvage value of $2,000 at the end of 7 years. (a) Compute the depreciation for each of the years of its life using: (i) SYD, (ii) DDB, and (iii) MACRS method (life for furniture in MACRS is 7 years) (b) Compute the NPV of the depreciation schedule for each of the three methods using i = 10%. (c) Considering the NPV values, which method...

Office Furniture Inc. sells modular desk units and office chairs in the ratio of 3:2. That...

Office Furniture Inc. sells modular desk units and office chairs in the ratio of 3:2. That is 3 desk units for every 2 chairs sold. The selling prices are $1,280 per desk unit and $540 per chair. The variable costs are $760 per desk unit and $270 per chair. Shared fixed costs total $160,000. a) Prepare a schedule to compute the selling price and variable cost per composite unit. b) Compute the break-even point in composite units. c) Compute the...

RougeRiver Furniture Limited projects unit sales for a new line of office desk to be as...

RougeRiver Furniture Limited projects unit sales for a new line of office desk to be as follows: Year 1 2 3 4 5 Sales 2,000 4,000 5,000 3,000 1,000 Production of office desks will require net working capital each year equal to 20% of the sales revenues of the following year. Any remaining net working capital will be fully recovered at the end of year 5. Total fixed costs are $100,000 per year, variable costs are $80 per unit, and...

A furniture supplier, Acme Chairs, Inc., manufactures a Basic office chair and a Deluxe office chair....

A furniture supplier, Acme Chairs, Inc., manufactures a Basic office chair and a Deluxe office chair. Each Basic chair costs $25.00 to manufacture, and each Deluxe office chair costs $40.00 to manufacture. Acme Chairs wishes to determine the optimal production quantities per day for each chair model in order to minimize overall total cost. The production of each chair requires three types of materials: Wood, Primer, and Paint. The amount of material available per day to manufacture the chairs is...

Oficina Bonita Company manufactures office furniture. An unfinished desk is produced for $34.55 and sold for...

Oficina Bonita Company manufactures office furniture. An unfinished desk is produced for $34.55 and sold for $65.65. A finished desk can be sold for $74.00. The additional processing cost to complete the finished desk is $6.60. Prepare a differential analysis. Round your answers to two decimal places. Differential Analysis Sell Unfinished (Alternative 1) or Process Further into Finished (Alternative 2) Desks Sell Unfinished Desks (Alternative 1) Process Further into Finished Desks (Alternative 2) Differential Effects (Alternative 2) Revenues per desk...

Oficina Bonita Company manufactures office furniture. An unfinished desk is produced for $37.50 and sold for...

Oficina Bonita Company manufactures office furniture. An unfinished desk is produced for $37.50 and sold for $64.25. A finished desk can be sold for $75.00. The additional processing cost to complete the finished desk is $6.00. Prepare a differential analysis. Round your answers to two decimal places. Differential Analysis Sell Unfinished (Alternative 1) or Process Further into Finished (Alternative 2) Desks Sell Unfinished Desks (Alternative 1) Process Further into Finished Desks (Alternative 2) Differential Effects (Alternative 2) Revenues per desk...

Oficina Bonita Company manufactures office furniture. An unfinished desk is produced for $34.30 and sold for...

Oficina Bonita Company manufactures office furniture. An unfinished desk is produced for $34.30 and sold for $64.30. A finished desk can be sold for $74.00. The additional processing cost to complete the finished desk is $6.00. Prepare a differential analysis. Round your answers to two decimal places. Differential Analysis Sell Unfinished (Alternative 1) or Process Further into Finished (Alternative 2) Desks Sell Unfinished Desks (Alternative 1) Process Further into Finished Desks (Alternative 2) Differential Effects (Alternative 2) Revenues per desk...

Hiroole sells computer equipment and home office furniture. Currently the furniture product line takes up approximately...

Hiroole sells computer equipment and home office furniture. Currently the furniture product line takes up approximately 50 percent of the company’s retail floor space. The president of Hiroole is trying to decide whether the company should continue offering furniture or concentrate on computer equipment. Below is a product line income statement for the company. If furniture is dropped, salaries and other direct fixed costs can be avoided. In addition, sales of computer equipment can increase by 13 percent without affecting...

Acme Rentals Inc. has the following projected cash flows for the next two months: (000s) February...

Acme Rentals Inc. has the following projected cash flows for the next two months: (000s) February March Cash inflows $980 $877 Cash outflows 930 983 a. The company has a target cash balance of $20,000 and will start February with $15,000. What is the company’s forecasted cumulative surplus or borrowing requirements for February and March? Calculations needed. (2 points) b. Acme has a $45,000 line of credit available to borrow if they are short of funds. Is Acme’s line of...