Question

Oriole Tooling Ltd. is assessing two available options for the purchase of new equipment with a negotiated cash price of $180,000. The manufacturer is willing to accept a down payment of 20% of the purchase price and an instalment note for the balance. The note would require quarterly fixed principal payments (plus interest) starting October 1, 2020, for a period of two years. Oriole has a proposal from its bank for an instalment loan for two years that requires a fixed blended monthly payment (including both principal and interest) starting August 1, 2020. The loan would be for 80% of the equipment’s purchase price. The current market rate of interest is 6%. Both contracts have an interest rate of 6%.

Is there any measurement uncertainty in determining which option is best for Oriole?



Which discounted cash flow approach should be used in the comparison of the two alternatives?

Answer 1

Given the negotiated cash price = 1,80,000

Amount of down payment = 36,000

Amount of Loan = 1,80,000 - 36000 = 1,44,000

Let us prepare a schedule inorder to find out the quarterly payments and interest

Option-1) Quarterly fixed payment plus interest.

Quarter	Opening Principal	Interest @ 1.5%	Principal Repayment	Total Payment	Closing loan balance
1	1,44,000	2,160	18,000	20,160	1,26,000
2	1,26,000	1,890	18,000	19,890	1,08,000
3	1,08,000	1,620	18,000	19,620	90,000
4	90,000	1,350	18,000	19,350	72,000
5	72,000	1,080	18,000	19,080	54,000
6	54,000	810	18,000	18,810	36,000
7	36,000	540	18,000	18,540	18,000
8	18,000	270	18,000	18,270	-

Total interest Charged - 9720

Present value of laon payments

Option-2) Monthly Installment.

The formula for calculating the monthly equalised installments is.

[P x R x (1+R)^N]/[(1+R)^N-1], where P stands for the loan amount or principal, R is the interest rate per month

Given Annual interest is 6% per annum hence monthly interest is 6/12 = 0.5% per month.

(1,44,000 * 0.005 * (1.005)^24)/((1.005)^24 -1)

= 6382

The amortization schedule for this is as follows.

Month	Opening Principal	Interest @ 0.5%	Principal Repayment	Fixed payment	Closing loan balance
1	1,44,000	720	5,662	6,382	1,38,338
2	1,38,338	692	5,690	6,382	1,32,648
3	1,32,648	663	5,719	6,382	1,26,929
4	1,26,929	635	5,747	6,382	1,21,182
5	1,21,182	606	5,776	6,382	1,15,405
6	1,15,405	577	5,805	6,382	1,09,601
7	1,09,601	548	5,834	6,382	1,03,767
8	1,03,767	519	5,863	6,382	97,903
9	97,903	490	5,892	6,382	92,011
10	92,011	460	5,922	6,382	86,089
11	86,089	430	5,952	6,382	80,137
12	80,137	401	5,981	6,382	74,156
13	74,156	371	6,011	6,382	68,145
14	68,145	341	6,041	6,382	62,104
15	62,104	311	6,071	6,382	56,032
16	56,032	280	6,102	6,382	49,930
17	49,930	250	6,132	6,382	43,798
18	43,798	219	6,163	6,382	37,635
19	37,635	188	6,194	6,382	31,441
20	31,441	157	6,225	6,382	jeff jeffy Next > < Previous Related Solutions Sheridan Tooling Ltd. is assessing two available options for the purchase of new equipment with a... Sheridan Tooling Ltd. is assessing two available options for the purchase of new equipment with a negotiated cash price of $100,000. The manufacturer is willing to accept a down payment of 20% of the purchase price and an instalment note for the balance. The note would require quarterly fixed principal payments (plus interest) starting October 1, 2020, for a period of two years. Sheridan has a proposal from its bank for an instalment loan for two years that requires a... M&B Tooling Ltd. is assessing two available options for the purchase of new equipment with a... M&B Tooling Ltd. is assessing two available options for the purchase of new equipment with a negotiated cash price of $100,000. The manufacturer is willing to accept a down payment of 20% of the purchase price and an instalment note for the balance. The note would require quarterly fixed principal payments (plus interest) starting October 1, 2020, for a period of two years. M&B has a proposal from its bank for an instalment loan for two years that requires a... ABC Ltd is negotiating for the purchase of a new piece of equipment for their current... ABC Ltd is negotiating for the purchase of a new piece of equipment for their current operations. The new equipment would replace existing equipment that was purchased 5 years ago for $50,000 and is being depreciated to zero on a straight-line basis over its effective life of 10 years. The old equipment has a current scrap value of $16,000 and it would be $1,000 in 5 years’ time. The supplier has quoted a selling price of $60,000 for the new... A homebuyer intends to purchase a $300,000 home. The two financing options available to the buyer... A homebuyer intends to purchase a $300,000 home. The two financing options available to the buyer are: 1) he can obtain 80% loan at a 4.25% interest rate with monthly payments amortizedover 30 years and total closing costs of 2.5% of the new loan. What is the APR for option 1? 2) He can obtain 95% FHA loan at a rate of 6.75% with monthly payments amortized over 30 years and total closing costs of 5.5% of the new loan.... Tank Ltd is considering undertaking the purchase of a new piece of equipment that is expected... Tank Ltd is considering undertaking the purchase of a new piece of equipment that is expected to increase pre-tax income(EBITDA) by $7,000 each year for the next 5 years. It costs $25,000 to purchase today and for tax purposes must be depreciated down zero over its 8 year useful life using the straight-line method. If Tank is actually forecasting a salvage (for capital budgeting purposes) of $8,000 after 5 years, what is the machine's net cash flow (after tax) for... Tank Ltd is considering undertaking the purchase of a new piece of equipment that is expected... Tank Ltd is considering undertaking the purchase of a new piece of equipment that is expected to increase revenue by $12,000 each year for six years. The equipment will increase costs $4,000 each year for six years. It costs $32,000 to purchase today and for tax purposes must be depreciated down to zero over its 8 year useful life using the straight-line method. If Tank is actually forecasting a salvage (for capital budgeting purposes) of $5,000 after 6 years, what... Decision You are considering the purchase of a new vehicle. There are two options for the... Decision You are considering the purchase of a new vehicle. There are two options for the auto acquisition: a traditional gas-powered auto or a hybrid auto. Based on the information provided below and using net present value (NPV), you will be evaluating the two options and making a recommendation. Note: this scenario is a least cost decision. Since the decision to buy a car will only involve costs, you will be choosing the option with the highest NPV (which in... A manufacturing company is evaluating two options for new equipment to introduce a new product to... A manufacturing company is evaluating two options for new equipment to introduce a new product to its suite of goods. The details for each option are provided below: Option 1 $65,000 for equipment with useful life of 7 years and no salvage value. Maintenance costs are expected to be $2,700 per year and increase by 3% in Year 6 and remain at that rate. Materials in Year 1 are estimated to be $15,000 but remain constant at $10,000 per year... A manufacturing company is evaluating two options for new equipment to introduce a new product to... A manufacturing company is evaluating two options for new equipment to introduce a new product to its suite of goods. The details for each option are provided below: Option 1  $65,000 for equipment with useful life of 7 years and no salvage value.  Maintenance costs are expected to be $2,700 per year and increase by 3% in Year 6 and remain at that rate.  Materials in Year 1 are estimated to be $15,000 but remain constant at $10,000 per year... Bernie Ltd is considering the purchase of a new equipment for its manufacturing plant and has... Bernie Ltd is considering the purchase of a new equipment for its manufacturing plant and has asked you to work out an appropriate discount rate to use when evaluating the project. information about burnie’s current capital structure is as follows: Source of capital. Book value. Market value debts. $1,500,000. $1,600,000 ordinary share capital. $1,800,000. $3,000,000 total. $3,300,000. $3,600,000 to finance the purchase, Bernie can sell 10 year-bonds paying annual coupon interest at a rate of 6%. The bond can be... ADVERTISEMENT Subjects Accounting Advanced Math Anatomy and Physiology Biology Chemistry Civil Engineering Computer Science Economics Electrical Engineering Finance History Math Mechanical Engineering Operations Management Physics Psychology Statistics and Probability Nursing Other ADVERTISEMENT Latest Questions Draw a DFA for the following ( ∑ = {0,1}):                                 Set of all strings with. In the article from Forbes notes that the goal of a leader is not to clone... Many people keep time using a 24 hour clock (11 is 11am and 23 is 11pm,... UNIX ONLY -- DIFFICULT LAB ASSIGNMENT This is an extremely difficult subject for me. Could you... Do you know why your credit card can be refused even though you are profitable? The Following Java expression: S/10 * 10 + 10 – S = C Show that this... Year Cash Flow 0 −$9,700           1 5,800           2 2,500           3 3,400      &nb ADVERTISEMENT About @ 2020 WizEdu