Question

In: Finance

Present value with periodic rates.   Sam​ Hinds, a local​ dentist, is going to remodel the dental...

Present value with periodic rates.

  Sam​ Hinds, a local​ dentist, is going to remodel the dental reception area and add two new workstations. He has contacted​ A-Dec, and the new equipment and cabinetry will cost ​$20,000.  The purchase will be financed with an interest rate of 7.5​% loan over 8 years. What will Sam have to pay for this equipment if the loan calls for quarterly payments (4 per​ year) and weekly payments ​(52 per​ year)? Compare the annual cash outflows of the two payments. Why does the weekly payment plan have less total cash outflow each​ year?

Solutions

Expert Solution

Answer : calculation of Payments to be made in each case :

In case of Semiannual Payment :

Uisng PMT function of Excel

=PMT(rate,nper,pv,fv)

where,

rate is rate of interest per period i.e 7.5% / 4 (As there are two payments in a year therefore divided by 4)

nper is the number of payments i.e 8 * 4 = 32 (As there are two payments in a year therefore multiplied by 4)

pv is the amount Required i.e -20000

fv is future value i.e 0

=PMT(7.5%/4,32,-20000,0)

Therefore Quarterly Payment is 836.81

In case of Weekly Payment :

Uisng PMT function of Excel

=PMT(rate,nper,pv,fv)

where,

rate is rate of interest per period i.e 7.5% / 52 (As there are 52 payments in a year therefore divided by 52)

nper is the number of payments i.e 8 * 52 = 416 (As there are 52 payments in a year therefore multiplied by 52)

pv is the amount Required i.e -20000

fv is future value i.e 0

=PMT(7.5%/52,416,-20000,0)

Therefore Weekly Payment is 63.97

To compare the annual cash flow in both alternative we can see that

Annual Cash Flow in Quarterly Payment = 836.81 * 4 =3347.24

Annual Cash Flow in Weekly Payment = 63.97 * 52 = 3326.30

By making Monthly payment the principal is also paying month by month and interest expense is also less , therefore total payment in Weekly option is less than Quarterly option.


Related Solutions

Present value with periodic rates. Sam​ Hinds, a local​ dentist, is going to remodel the dental...
Present value with periodic rates. Sam​ Hinds, a local​ dentist, is going to remodel the dental reception area and add two new workstations. He has contacted​ A-Dec, and the new equipment and cabinetry will cost ​$16,000. The purchase will be financed with an interest rate of 9.5​% loan over 6 years. What will Sam have to pay for this equipment if the loan calls for semiannual payments (2 per​ year) and monthly payments (12 per​ year)? Compare the annual cash...
Present value with periodic rates.   Sam​ Hinds, a local​ dentist, is going to remodel the dental...
Present value with periodic rates.   Sam​ Hinds, a local​ dentist, is going to remodel the dental reception area and add two new workstations. He has contacted​ A-Dec, and the new equipment and cabinetry will cost ​$15 comma 000 . The purchase will be financed with an interest rate of 8.5 ​% loan over 9 years. What will Sam have to pay for this equipment if the loan calls for semiannual payments ​(2 per​ year) and weekly payments ​(52 per​ year)?...
Present value with periodic rates.   Sam​ Hinds, a local​ dentist, is going to remodel the dental...
Present value with periodic rates.   Sam​ Hinds, a local​ dentist, is going to remodel the dental reception area and add two new workstations. He has contacted​ A-Dec, and the new equipment and cabinetry will cost $24,000. The purchase will be financed with an interest rate of 9​% loan over 8 years. What will Sam have to pay for this equipment if the loan calls for semiannual payments (2 per​ year) and monthly payments (12 per​ year)? Compare the annual cash...
Sam​ Hinds, a local​ dentist, is going to remodel the dental reception area and add two...
Sam​ Hinds, a local​ dentist, is going to remodel the dental reception area and add two new workstations. He has contacted​ A-Dec, and the new equipment and cabinetry will cost ​$22 comma 000. The purchase will be financed with an interest rate of 8​% loan over 8 years. What will Sam have to pay for this equipment if the loan calls for semiannual payments ​(2 per​ year) and monthly payments ​(12 per​ year)? Compare the annual cash outflows of the...
Sam Hinds, a local dentist, is going to remodel the dental reception area and add two new workstations.
Present value with periodic rates.Sam Hinds, a local dentist, is going to remodel the dental reception area and add two new workstations. He has contacted A-Dec, and the new equipment and cabinetry will cost $22,000.The purchase will be financed with an interest rate of 8% loan over 7 years. What will Sam have to pay for this equipment if the loan calls forsemiannual payments (2 per year) and monthly payments (12 per year)? Compare the annual cash outflows of the...
Sam Hinds, a local dentist, is going to remodel the dentist reception area and add two...
Sam Hinds, a local dentist, is going to remodel the dentist reception area and add two new workstations. he has contracted A-Dec, and the new equipment and cabinetry will cost $20,000. the purchase will be financed with an interest rate of 9.5% loan over 7 years. what will Sam have to pay for this equipment if the loan calls for semiannual payments (2 per year) and monthly payments (12 per year)? Compare the annual cash outflows of the two payments....
Determining the present value of bonds payable Interest rates determine the present value of future amounts
  Question: Determining the present value of bonds payable Interest rates determine the present value of future amounts. (Round to the nearest dollar.) Requirements 1. Determine the present value of 10-year bonds payable with face value of $86,000 and stated interest rate of 14%, paid semiannually. The market rate of interest is 14% at issuance. 2. Same bonds payable as in Requirement 1, but the market interest rate is 16%. 3. Same bonds payable as in Requirement 1, but the...
Find the periodic payment for the following simple annuity due. Future Value $21,200 Present Value _________?...
Find the periodic payment for the following simple annuity due. Future Value $21,200 Present Value _________? Payment Period 1 month Term of Annuity 10 years Interest Rate 11% Conversion Period monthly The periodic payment is ​$______ . ​(Round the final answer to the nearest cent as needed. Round all intermediate values to six decimal places as​ needed.)
What is the present day value of twenty annual periodic payments of $30,000 paid at the...
What is the present day value of twenty annual periodic payments of $30,000 paid at the end of each year at a discount rate of 2.7%?
You are going to receive $213,000 in 30 years. What is the difference in present value...
You are going to receive $213,000 in 30 years. What is the difference in present value between using a discount rate of 10 percent versus 5 percent? Use Appendix B as an approximate answer, but calculate your final answer using the formula and financial calculator methods. (Input your answer as a positive value. Do not round intermediate calculations. Round your final answer to 2 decimal places.)
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT