Solution to FM12 Ch 20 P06 Build a Model
4 Pages

Solution to FM12 Ch 20 P06 Build a Model

Course Number: FI FI504, Summer 2009

College/University: DeVry Chicago

Word Count: 800

Rating:

Document Preview

A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 B C D E F G H I 9/2/2006 Chapter 20. Solution to Ch 20-06 Build a Model 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...

Unformatted Document Excerpt
Coursehero >> Illinois >> DeVry Chicago >> FI FI504

Course Hero has millions of student submitted documents similar to the one
below including study guides, practice problems, reference materials, practice exams, textbook help and tutor support.

Course Hero has millions of student submitted documents similar to the one below including study guides, practice problems, reference materials, practice exams, textbook help and tutor support.

1 A 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 B C D E F G H I 9/2/2006 Chapter 20. Solution to Ch 20-06 Build a Model 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 the project's 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 $20,000 per year paid at the end of each year. The loom falls in the MACRS 5-year class, and Western's marginal federalplus-state tax rate is 40%. Gardial Automation Inc., maker of the loom, has offered to lease the loom to Westen for $70,000 upon delivery and installation (at t=0) plus 4 additional annual lease payments of $70,000 to be made at the ends of Years 1 through 4. (Note that there are 5 lease payments in total.) The lease agreement includes maintenance and servicing. Actually, the loom has an expected life of eight years, at which time its expected salvage value is zero; however, after 4 years, its market value is expected to equal its book value of $42,500. Tanner-Woods plans to build and entirely new plant in 4 years, so it has no interest in either leasing or owning the proposed loom for more than that period. 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 Length of loan Loan Interest rate Maintenance fee Tax Rate Lease fee Equipment expected life Expected salvage value Market value after 4 years Book value after 4 years $250,000 4 10% $20,000 40% $70,000 8 $0 $42,500 $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 = Year Beginning loan balance Interest payment Principal payment Ending loan balance $78,868 1 $250,000 $25,000 $53,868 $196,132 2 $196,132 $19,613 $59,254 $136,878 3 $136,878 $13,688 $65,180 $71,698 4 $71,698 $7,170 $71,698 $0 Now, we see that the decision being made is whether to purchase the equipment at a net cost of $250,000 (with annual payments of $78,868) or lease the equipment and make annual payments of $70,000. To make this decision, we must analyze the incremental cash flows. Now, we see that the decision being made is whether to purchase the equipment at a net cost of $250,000 (with annual A B D E H payments of $78,868) or lease theC equipment and make annual payments ofF$70,000. To G make this decision, we mustI 55 analyze the incremental cash flows. 56 A 57 58 59 60 61 62 63 64 65 66 67 69 68 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 B C D E F G H I Before proceeding with our NPV analysis we must determine the schedule of depreciation charges for this new equipment. MACRS 5-year Depreciation Schedule Year 1 2 Depr. Rate 20% 32% Depr. Exp. $50,000 $80,000 3 19% $47,500 4 12% $30,000 5 11% $27,500 6 6% $15,000 We can now construct our table of incremental cash flows from these two alternatives. Remember, that the appropriate discount rate in this scenario is the after tax cost of borrowing, or: 10%*(1-40%) = 6%. NPV LEASE ANALYSIS OF INCREMENTAL CASH FLOWS Year = Cost of ownership Purchase cost Loan proceeds After-tax interest payment Principal payment Maintenance cost Tax savings from maintenance cost Tax savings from depreciation Salvage value Net cash flow from ownership PV cost of ownership Cost of leasing Lease payment Tax savings from lease payment Net cash flow from leasing PV cost of leasing Cost Comparison PV ownership cost @ 6% PV of leasing @ 6% Net Advantage to Leasing 0 ($250,000) $250,000 ($15,000) ($53,868) ($20,000) $8,000 $20,000 $0 ($185,112) ($60,868) ($11,768) ($59,254) ($20,000) $8,000 $32,000 ($51,022) ($8,213) ($65,180) ($20,000) $8,000 $19,000 ($66,393) ($4,302) ($71,698) ($20,000) $8,000 $12,000 $42,500 ($33,500) 1 2 3 4 ($70,000) $28,000 ($42,000) ($187,534) ($70,000) $28,000 ($42,000) ($70,000) $28,000 ($42,000) ($70,000) $28,000 ($42,000) ($70,000) $28,000 ($42,000) ($185,112) ($187,534) ($2,423) Our NPV Analysis has told us that there is a negative advantage to leasing. We interpret that as an indication that the firm should forego the opportunity to lease and buy the new equipment. 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 A B C D E F G H I b. The salvage value is clearly the most uncertain cash flow in the analysis. Assume that the appropriate salvage value pre-tax discount rate is 15 percent. What would be the effect of a salvage value risk adjustment on the decision? All cash flows would remain unchanged except that of the salvage value. Our new array of cash flows would resemble the following: Standard discount rate Salvage value rate Year = Net cash flow PV of net cash flows NPV of ownership New Cost Comparison PV ownership cost @ 6% PV of leasing @ 6% Net Advantage to Leasing 10% 15% 0 $0 $0 ($188,667) 1 ($60,868) ($57,422) 2 ($51,022) ($45,410) 3 ($66,393) ($55,744) 4 ($76,000) ($60,199) 4 $42,500 $30,108 ($188,667) ($187,534) $1,133 Under this new assumption of using a greater discount factor for the salvage value, we find that the firm should lease, and not buy, the equipment. c. Assuming that the after-tax cost of debt should be used to discount all anticipated cash flows, at what lease payment would the firm be indifferent to either leasing or buying? We will use the Goal Seek function to determine the lease payment that makes the Net Advantage to Leasing zero. Crossover = 69,096

Find millions of documents on Course Hero - Study Guides, Lecture Notes, Reference Materials, Practice Exams and more. Course Hero has millions of course specific materials providing students with the best way to expand their education.

Below is a small sample set of documents:

DeVry Chicago - FI - FI504
A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26BCDEFGHChapter 21. Solution to Ch 21-08 Build a ModelNiendorf Incorporated needs to raise $25 million to construct production facilities for a new type of USB mem
DeVry Chicago - FI - FI504
9/4/2006Chapter 22. Solution to Ch 22 P18 Build a ModelInput Data Collections during month of sale Collections during month after sale Collections during second month after sale Lease payments Target cash balance General and administrative salari
DeVry Chicago - FI - FI504
25b02f085cf2eb6ded546adc8cad10c42101015a.xlsBuild a Model 9/6/2006Chapter 23. Solution to Ch 23-06 Build a ModelProblem 23-6. Use the information and data from Problem 23-5 Problem Inputs: Size of planned debt offering = Anticipated rate on debt
DeVry Chicago - FI - FI504
9/8/2006Chapter 24. Solution for Ch 24-5 Build a ModelAt the time it defaulted on its interest payments and filed for bankruptcy, the McDaniel Mining Company had the following balance sheet (in thousands of dollars). The court, after trying unsuc
DeVry Chicago - FI - FI504
A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59BCDEFGHIJ 9/14/2006Chapter 25. Solution to 25-07 Build a Mode
DeVry Chicago - FI - FI504
A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50BCDEFGHI 9/20/2006Chapter 26. Solution to Ch 26-15 Build a ModelYohe Telecommunications
DeVry Chicago - FI - FI504
A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41BCDEFGHChapter 27. Solution to Ch 27-12 Build a ModelMalone Feed and Supply Company buys on terms of 1/10, net 30, but
DeVry Chicago - FI - FI504
Chapter 28. Solution to Ch 28-3 Build a ModelThe following inventory data have been established for the Alder Corporation: (1) Orders must be placed in multiples of 100 units. (2) Annual sales are 338,000 units. (3) The purchase price per unit is $3
Stanford - ENGR - 30
Stanford - ENGR - 30
Stanford - ME - 70
PROBLEM SET 5 SOLUTIONSProf. Cappelli Winter 2008-09ME 70 Problems due Wednesday February 11, 2008 Linear Momentum Conservation (and sometimes Bernoulli's Equation) Problem 4.98 (Fox, McDonald, and Pritchard) Problem 4.105 (Fox, McDonald, and Prit
Stanford - ME - 70
Stanford - ME - 70
Stanford - ME - 70
Stanford - ME - 70
Stanford - ME - 70
Winter 08-09SOLUTIONSME 70 Problems due Wednesday January 28, 2009 Forces on Submerged Surfaces and Line of Action Solve: Problem 3.64 (Fox, McDonald, and Pritchard 7th Edition) Problem 3.72 (Fox, McDonald, and Pritchard 7th Edition) you will have
Stanford - ME - 70
ME 70 Final Exam June 9, 2008 This is an open textbook only test. Supplemental notes can augment the text, but they must be inserted and firmly attached to the textbook. Some useful numbers: air = 1.23 kg/m3 air = 1.8 x 10-5 Ns/m2 air = 1.5 x 10-5
Stanford - ME - 70
ME 70 Solutions Set 1 Winter 2008-09ME 70 Problem Set 1 SOLUTIONS Problem 1.ME 70 Solutions Set 1 Winter 2008-092.32 x 1024 m-32.32 x 1024 m-3 0.116 kg- m-30.116 17.2 km(2.32 x 1024)-1/3 7.55 x 10-9 m 7.55 x 10-9 m17,237 m1 0.1 0.01 Me
Stanford - ME - 70
SOLUTIONSME 70 Problems due Wednesday February 4, 2009 Momentum Flux Solve: Problem 4.55 (Fox and McDonald 7th Edition) Combined Mass, and Momentum Balances Solve: Problem 4.62 (Fox and McDonald 7th Edition) Problem 4.70 (Fox and McDonald 7th Editio
Stanford - ME - 70
Prof. Cappelli Winter 2008-09 ME 70 Problems due Wednesday February 18, 2009 Energy Balances Solve Problem 4.198 (7th Edition, Fox, McDonald, and Pritchard) Problem 4.203 (7th Edition, Fox, McDonald, and Pritchard) More Bernoulli, Euler "s", and Eule
Stanford - ME - 70
SOLUTIONSME 70 Problems due Wednesday January 21, 2009 Hydrostatics (Pressure-Depth Relation) Solve: Problem 3.17 (Fox, McDonald and Pritchard) Problem 3.24 (Fox, McDonald and Pritchard) Buoyancy Solve: Problem 3.88 (Fox, McDonald and Pritchard) Rig
Stanford - SPANLANG - 15
Los Simpson Quin no conoce a esta familia?Todo empez el da en que Homer J.Simpson se declar a Marge Bouvier, y por algn motivo que desconozco, ella acept la peticin de matrimonio. Los Simpson son, por un lado, una familia peculiar, pero por otro lad
Stanford - SPANLANG - 15
Espaol 1 Fecha:_ Composicin #3- PRIMER I. ContenidoNombre del autor/a: _ Nombre del editor/a: _BORRADOR- ANALISIS DEL CONTENIDO1. Se describe el bilingismo del compaero con suficientesdetalles? (sus experiencias, sus opiniones, etc.) Si / No M
Stanford - SPANLANG - 15
Months, Seasons, and Dates Here are the months in Spanish. Note that, like the days of the week, they are not capitalized. enero . January febrero . February marzo . March abril .. April mayo . May junio . June julio . July agosto . August septiembr
Stanford - SPANLANG - 15
-> http:/www.scola.org Login: Password: Stanford_VS001 1891Jordan
Stanford - SPANLANG - 15
Hablando de la salud. (Talking about health) desmayarse estornudar fracturarse romperse quebrarse Me fractur la pierna (la nariz). Me romp el brazo (la rodilla). Me quebr la mueca (el dedo) vomitar tener. una alergia a. catarro una cortada diarrea do
Stanford - SPANLANG - 15
IMPERFECTOBefore studying the grammar explanation, answer the question based on the dialogue: Do the sentences ,practicaba todos los das." and ,Yo tambin jugaba mucho" Refer to actions that occured only once on the past or to habitual actions in t
Stanford - SPANLANG - 15
PRESENTACIN DE MI COMPAER@ . TEMA:. Conocimiento previo: Quiero recordar de esta presentacin:Quiero preguntar: Mi opinin:PRESENTACIN MI MI COMPAER@ . PRESENTACIN DEDE COMPAER@ . TEMA:.. TEMA:.Conocimiento previo: Quiero recordar de esta presenta
Stanford - SPANLANG - 15
EL CUERPOel ojo la nariz el cuello el hombro el pecho el codo la mueca la mano la cadera la pierna el taln el piela cabeza la oreja la boca la barbilla el brazo la tripa el ombligo el dedo el muslo la rodilla la tibia / la pantorrilla el tobillo
Stanford - SPANLANG - 15
Cmo elegir un tema para el informe oral y prepararloPaso 1 - Seleccin de tema (semana 8)Lluvia de ideas: Think about the skills you've practiced throughout the quarter (e.g., description in the present and past) and the broader topics we've studied
Stanford - SPANLANG - 15
Espaol 1 Edicin de composicin #2Nombre del autor: _ Nombre del editor: _Paso 1. Read your partner's composition and check for the following:Formato: The composition has a title h It is double-spaced h It is typewritten hPaso 2.Contenido: 1. M
Stanford - SPANLANG - 15
Read the questions below, then read the attached descriptions of some academic programs at a university in Ecuador. Answer the questions in English. 1. Name the three academic disciplines outlined below, and give one general fact about the program in
Stanford - SPANLANG - 15
PRCTICA ORAL -Espaol 2 Answer each of these questions in a full sentence. Cmo te llamas? Cuntos aos tienes? En qu ao naciste? De dnde eres? En qu te especializas? Qu materias tomas? Dnde vives? Qu tiempo hace hoy?QuickTimeand a TIFF (Uncompressed)
Stanford - SPANLANG - 15
Situacin: Ay, mi compa de cuarto!Persona A: Your compaero/a de cuarto has done it again! S/He's wore your favorite shirt (without your permission!) for a "special date" and then spilled red wine all over it. Express your shock and anger to your room
Stanford - SPANLANG - 15
Stanford Spanish Language Program9/23/08 4:50 PMLA COMIDA: Cmo es.? Puedes describir e identificar los alimentos segn su: CATEGORA: carne, marisco, verdura, postre, bebida, legumbre, tubrculo. COLOR TAMAO: grande, pequeo, mediano, enorme, minscul
Stanford - SPANLANG - 15
Stanford - HUMBIO - 4a
Part 1 1) C The visual, gustatory and olfactory systems all use a combinatorial code to interpret an image, taste or smell in the brain. All of these systems react to stimuli via their 7-pass transmembrane proteins such as G-proteins or opsin. While
Stanford - HUMBIO - 4a
4A Problem Set 1 RationalesPart 1 1. C Modified Student Rationale: "A" is false because the number of open K+ leak channels stays constant during action potentials, while "B" is false because the activity of Na/K+ pumps does not change during action
Stanford - HUMBIO - 4a
Human Biology 4B Final Exam June 13, 2007 PART 1: MULTIPLE CHOICE QUESTIONS 1D 2C 3B 4E 5D 6C 7E 8B 9C 10 A 11 C 12 A 13 C 14 A 15 A 16 D 17 D 18 E 19 A 20 A 21 C 22 C 23 D 24 B 25 B 26 B 27 C 28 A 29 A 30 B 31 B 32 A 33 D 34
Stanford - HUMBIO - 4a
Human Biology 4B (Spring 2008) Study Questions for the Final Exam These questions will guide you in considering the material you have learned throughout the quarter. Please note that the study questions are not exhaustive, and exam questions will dra
Stanford - HUMBIO - 4a
Pset 5 Rationales PART 1 1) B Calcitonin (released by the thyroid gland) and PTH (released by the parathyroid gland) work in opposition to each other to maintain homeostatic blood Calcium levels. While Calcitonin stimulates bone growth by inhibiting
Stanford - HUMBIO - 4a
REVIEWSPREFRONTAL AND MEDIAL TEMPORAL LOBE INTERACTIONS IN LONG-TERM MEMORYJon S. Simons* and Hugo J. SpiersCognitive neuroscience has made considerable progress in understanding the involvement of the medial temporal and frontal lobes in long-te
Stanford - HUMBIO - 4a
4A Final Thought QuestionsNote: These thought questions are not necessarily representative of the exam. They are meant to be a guide to help your studying only. There may be things tested which are not referred to in the questions, and there are que
Stanford - HUMBIO - 4a
HUMAN BIOLOGY 4AReview/Thought Questions for the Midterm, 2008This guide is intended to help you think about, review and integrate the material from the class, problem sets, virtual lab and text books. While we believe this guide will be useful it
Stanford - HUMBIO - 4a
HumBio 4B Midterm 2008 Thought Questions These questions will guide you in integrating the diverse material you have learned throughout the quarter. Please note that the study questions are not exhaustive, and exam questions will draw on all of the r
DeVry Chicago - FI - FI504
6/26/2006 Chapter 5. Solution to Ch 05 P24 Build a ModelRework Problem 5-12 using a spreadsheet. After completing questions a through d, answer the new question. A 10-year 12 percent semiannual coupon bond, with a par value of $1,000, may be called
University of Colombo - MCCU - MCCU 1000
ARE WE STILL ON NEWSPAPERS? MAGAZINES.NO.WE'VE MOVED TOYEAH! 1955, TWO MEN ADMITTED TO THE LYNCHING I'M SORRY, THEY DIDN'T ADMIT TO IT IN EMMITT TILL, 14-YEAR- THESE TWO ADMIT TODAYOF EMMITT TILL.1955, THE LYNCHING HAPPENED THEN. OLD LITTLE
University of Texas - CH - 90262
fernandez (jf23742) H02: Chapter 17 McCord (90262) This print-out should have 29 questions. Multiple-choice questions may continue on the next column or page find all choices before answering. A reminder that EXAM 1 is on Monday, August 20th, fro
LSU - EE - 4720
mr-1Spring 2001 Midterm Exam Reviewmr-1When / WhereWednesday, 21 March, 13:40-14:30 CSTCEBA 1112 (Here)ConditionsClosed Book, Closed NotesBring one sheet of notes (both sides), 216 mm 280 mm.No communication devices unless a fair wa
LSU - EE - 4720
03-1Instruction Set (ISA) Design and Addressing Modes03-1 03-2ISA Design Decisions03-2Material from sections 2.1, 2.2, and 2.3. I. OrganizationA. Data types (supported by ISA). B. Memory and register organization. C. Addressing modes.Outl
LSU - EE - 4720
10-1Dynamic Scheduling10-1This Set Scheduling and Dynamic Execution Definitions From various parts of Chapter 4. Description of Two Dynamic Scheduling MethodsNot yet complete.(Material below may repeat material above.) Tomasulo's Algo
LSU - EE - 4720
02-1Components of CPU Performance and Performance Equation02-1Why is my computer fast (or slow)? ?Would it help to improveCPU performance equation is one way to start answering these questions.02-1EE 4720 Lecture Transparency. Formatted
LSU - EE - 4720
NameComputer Architecture EE 4720 Final Examination8 May 2000, 10:0012:00 CDTProblem 1 Problem 2 Problem 3 Problem 4 Problem 5 Alias Good Luck!(20 pts) (10 pts) (10 pts) (21 pts) (39 pts) (100 pts)Exam TotalProblem 1: An extended DLX ISA,
LSU - EE - 4720
10-1Dynamic Scheduling10-1 10-2Dynamic Scheduling10-2This Set Scheduling:Organizing instructions to improve execution efficiency. Scheduling and Dynamic Execution Definitions From various parts of Chapter 4. Static Scheduling:Organizing
LSU - EE - 4720
01-1EE 4720-Computer Architecture01-1URL: http:/www.ece.lsu.edu/ee4720/RSS: http:/www.ece.lsu.edu/ee4720/rss home.xmlOffered by:David M. Koppelman349 EE Building, 578-5482, koppel@ece.lsu.edu, http:/www.ece.lsu.edu/koppelOffice Hours:
LSU - EE - 4720
01-1EE 4720-Computer Architecture01-1Call Number 1825 (Fall 2002)URL: http:/www.ece.lsu.edu/ee4720Offered by:David M. Koppelman349 EE Building578-5482, koppel@ece.lsu.edu, http:/www.ece.lsu.edu/koppel/koppel.htmlTentative office hou
LSU - EE - 4720
fr-1Fall 2003 Final Exam Reviewfr-1When / WhereTuesday, 9 December 2003, 10:00-12:00 CST (Here).ConditionsClosed Book, Closed NotesBring one 215 280 mm note sheet.Cannot use communication devices.FormatTwo or three or maybe four p
LSU - EE - 4720
mr-1Fall 2005 Midterm Exam Reviewmr-1When / WhereMonday, 24 October 2005, 12:40-13:30 CDTCEBA 2142 (Here)ConditionsClosed Book, Closed NotesBring one sheet of notes (both sides), 216 mm 280 mm.No use of communication devices.Forma
LSU - EE - 4720
mr-1Fall 2007 Midterm Exam Reviewmr-1When / WhereWednesday, 7 November 2007, 10:40-11:30 CSTTaylor 3142 (Here)ConditionsClosed Book, Closed NotesBring one sheet of notes (both sides), 216 mm 280 mm.No use of communication devices.
LSU - EE - 4720
mr-1Fall 2008 Midterm Exam Reviewmr-1When / WhereFriday, 31 October 2008, 10:40-11:30 Central Daylight TimeTaylor Hall 3142 (Here)ConditionsClosed Book, Closed NotesBring one sheet of notes (both sides), 216 mm 280 mm.No use of comm
LSU - EE - 4720
NameSolutionComputer Architecture EE 4720 Final Examination13 December 2005, 12:3014:30 CSTProblem 1 Problem 2 Problem 3 Problem 4 Problem 5 Alias Out-of-order graduation? Good Luck!(15 pts) (20 pts) (17 pts) (15 pts) (33 pts) (100 pts)Exa