FM11_Ch_20_P06_Build_a_Model

FM11_Ch_20_P06_Build_a_Model - A 1 2 3 4 5 6 7 8 9 10 11 12...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
7/3/2003 Chapter 20. Ch 20-06 Build a Model a. Should the loom be leased or purchased? First, we want to lay out all of the input data in the problem. INPUT DATA Invoice Price $250,000 Length of loan 4 Loan Interest rate 10% Maintenance fee $20,000 Tax Rate 40% Lease fee $70,000 Equipment expected life 8 Expected salvage value $0 Market value after 4 years $42,500 Book value after 4 years $42,500 First, we can determine the annual loan payment that must be made on the new equipment. We will do so using the function wizard for PMT. Annual loan payment = ($78,868) Year 1 2 3 4 Beginning loan balance $250,000 $196,132 $136,878 $71,698 Interest payment ($25,000) ($19,613) ($13,688) ($7,170) Principal payment ($53,868) ($59,254) ($65,180) ($71,698) Ending loan balance $196,132 $136,878 $71,698 $0 As part of its overall plant modernization and cost reduction program, Western Fabrics' management has decided to install a new automated weaving loom. In the capital budgeting analysis of this equipment, the IRR of the project was found to be 20% versus a project required return of 12%. The loom has an invoice price of $250,000, including delivery and installation charges. The funds needed could be borrowed from the bank through a 4-year amortized loan at a 10% interest rate, with payments to be made at the end of each year. In the event that the loom is purchased, the manufacturer will contract to maintain and service it for a fee of
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 4

FM11_Ch_20_P06_Build_a_Model - A 1 2 3 4 5 6 7 8 9 10 11 12...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online