Question

In: Finance

The capital investment for a new highway paving machine is $950000. This expense is estimated, in...

The capital investment for a new highway paving machine is $950000. This expense is estimated, in year zero dollars, is $92600. This expense is estimated to increase at the rate of 5.7% per year. Assume that f=4.5%, N=7 years, MV at the end of the year 7 is 10% of the capital investment, and the MARR (in real terms) is 10.05% per year. What uniform annual revenue (before taxes), in actual dollars, would machine need to generate to break even?

f is the inflation rate

Solutions

Expert Solution

Given cash flows are in nominal (or actual) terms while MARR is in real terms so either convert all cash flows to real or MARR to nominal. We will convert MARR to nominal terms:

MARRnominal = MARRreal + inflation + MARRreal*inflation = 10.05% + 4.5% + (10.05%*4.5%) = 15.00%

For the machine to break even, its NPV should be zero. We can calculate the uniform annual revenue (before taxes) by setting NPV to 0 and solving for revenue, as follows:

Formula Year (n) 0 1 2 3 4 5 6 7
Capital investment (CI)           950,000
En-1*(1+5.7%) Expense (in nominal dollars) En         92,600.00         97,878.20     103,457.26     109,354.32     115,587.52     122,176.01     129,140.04
Revenue (in nominal dollars) Rn     335,057.18     335,057.18     335,057.18     335,057.18     335,057.18     335,057.18     335,057.18
En - Rn Net revenue (NR)     242,457.18     237,178.98     231,599.92     225,702.86     219,469.66     212,881.17     205,917.14
1/(1+d)^n Discount factor @15%                 0.870                 0.756                 0.657                 0.572                 0.497                 0.432                 0.376
NR*Discount factor PV of net revenue (PV)     210,828.20     179,334.37     152,271.77     129,036.24     109,104.54         92,023.60         77,401.28
PV - CI Total cash flow (CF) (950,000.00)     210,828.20     179,334.37     152,271.77     129,036.24     109,104.54         92,023.60         77,401.28
Sum of all CFs NPV                   0.00

The machine will break even at a revenue of 335,057.18 per annum.


Related Solutions

Cost of Production Report: No Beginning Inventories Howell Paving Company manufactures asphalt paving materials for highway...
Cost of Production Report: No Beginning Inventories Howell Paving Company manufactures asphalt paving materials for highway construction through a one-step process in which all materials are added at the beginning of the process. During April 2017, the company accumulated the following data in its process costing system: Production data Work-in-process, 4/1/17 0 tons Raw materials transferred to processing 25,000 tons Work-in-process, 4/30/17 (75% converted) 5,000 tons Cost data Raw materials transferred to processing $812,500 Conversion costs Direct labor cost incurred...
A new machine costs $120,000, has an estimated useful life of five years and an estimated...
A new machine costs $120,000, has an estimated useful life of five years and an estimated salvage value of $15,000 at the end of that time. It is expected that the machine can produce 210,000 widgets during its useful life. The New Times Company purchases this machine on January 1, 2017, and uses it for exactly three years. During these years the annual production of widgets has been 80,000, 50,000, and 30,000 units, respectively. On January 1, 2020, the machine...
Western Textiles is considering an investment in a new weaving machine. This machine is for a...
Western Textiles is considering an investment in a new weaving machine. This machine is for a growth opportunity, so the new machine will not replace an existing machine. The new machine is priced at $214,000 and will require installation costing $26,000. WT plans to use the machine for 4 years, while it will be depreciated using the MACRS method over its 3-year class life, and then plans to sell the machine at its expected salvage value of $80,000 at the...
A fixed capital investment of P10,000,000 is required for a proposed manufacturing plant and an estimated...
A fixed capital investment of P10,000,000 is required for a proposed manufacturing plant and an estimated working capital of P2,000,000. Annual depreciation is estimated to be 10% of the fixed capital investment. Determine the rate of return on the total investment if the annual profit is P2,500,000.  Determine the payout period if the annual profit is P2,500,000
The capital investment committee of Arches Landscaping Company is considering two capital investments. The estimated income...
The capital investment committee of Arches Landscaping Company is considering two capital investments. The estimated income from operations and net cash flows from each investment are as follows: Front-End Loader Greenhouse Year Income from Operations Net Cash Flow Income from Operations Net Cash Flow 1 $63,000 $205,000 $132,000 $328,000 2 63,000 205,000 101,000 277,000 3 63,000 205,000 50,000 195,000 4 63,000 205,000 22,000 133,000 5 63,000 205,000 10,000 92,000 Total $315,000 $1,025,000 $315,000 $1,025,000 Each project requires an investment of...
The capital investment committee of Arches Landscaping Company is considering two capital investments. The estimated income...
The capital investment committee of Arches Landscaping Company is considering two capital investments. The estimated income from operations and net cash flows from each investment are as follows: Front-End Loader Greenhouse Year Income from Operations Net Cash Flow Income from Operations Net Cash Flow 1 $52,200 $164,000 $110,000 $262,000 2 52,200 164,000 84,000 221,000 3 52,200 164,000 42,000 156,000 4 52,200 164,000 18,000 107,000 5 52,200 164,000 7,000 74,000 Total $261,000 $820,000 $261,000 $820,000 Each project requires an investment of...
The capital investment committee of Arches Landscaping Company is considering two capital investments. The estimated income...
The capital investment committee of Arches Landscaping Company is considering two capital investments. The estimated income from operations and net cash flows from each investment are as follows: Front-End Loader Greenhouse Year Income from Operations Net Cash Flow Income from Operations Net Cash Flow 1 $35,700 $116,000 $75,000 $186,000 2 35,700 116,000 57,000 157,000 3 35,700 116,000 29,000 110,000 4 35,700 116,000 12,000 75,000 5 35,700 116,000 5,500 52,000 Total $178,500 $580,000 $178,500 $580,000 Each project requires an investment of...
The capital investment committee of Cross Continent Trucking Inc. is considering two capital investments. The estimated...
The capital investment committee of Cross Continent Trucking Inc. is considering two capital investments. The estimated income from operations and net cash flows from each investment are as follows: Warehouse Tracking Technology Year Income from Operations Net Cash Flow Income from Operations Net Cash Flow 1 $50,400 $163,000 $106,000 $261,000 2 50,400 163,000 81,000 220,000 3 50,400 163,000 40,000 155,000 4 50,400 163,000 18,000 106,000 5 50,400 163,000 7,000 73,000 Total $252,000 $815,000 $252,000 $815,000 Each project requires an investment...
The capital investment committee of Arches Landscaping Company is considering two capital investments. The estimated income...
The capital investment committee of Arches Landscaping Company is considering two capital investments. The estimated income from operations and net cash flows from each investment are as follows: Front-End Loader Greenhouse Year Income from Operations Net Cash Flow Income from Operations Net Cash Flow 1 $50,000 $161,000 $105,000 $258,000 2 50,000 161,000 80,000 217,000 3 50,000 161,000 40,000 153,000 4 50,000 161,000 18,000 105,000 5 50,000 161,000 7,000 72,000 Total $250,000 $805,000 $250,000 $805,000 Each project requires an investment of...
The capital investment committee of Arches Landscaping Company is considering two capital investments. The estimated income...
The capital investment committee of Arches Landscaping Company is considering two capital investments. The estimated income from operations and net cash flows from each investment are as follows: Front-End Loader Greenhouse Year Income from Operations Net Cash Flow Income from Operations Net Cash Flow 1 $41,800 $132,000 $88,000 $211,000 2 41,800 132,000 67,000 178,000 3 41,800 132,000 33,000 125,000 4 41,800 132,000 15,000 86,000 5 41,800 132,000 6,000 60,000 Total $209,000 $660,000 $209,000 $660,000 Each project requires an investment of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT