Question

In: Finance

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 two payments. Why does the monthly payment plan have less total cash outflow each​ year? What will Sam have to pay for this equipment if the loan calls for semiannual payments ​(2 per​ year)?

Solutions

Expert Solution

Monthly payment and annual cash outflows are:

Monthly payment = [P * R * (1+R)^N ] / [(1+R)^N -1]
Using the formula:
Loan amount P                                                           22,000.00
Rate of interest per period:
Annual rate of interest 8.000%
Frequency of payment = Once in 1 month period
Numer of payments in a year = 12/1 = 12
Rate of interest per period R 0.08 /12 = 0.6667%
Total number of payments:
Frequency of payment = Once in 1 month period
Number of years of loan repayment =                                                                          8
Total number of payments N 8*12 = 96
Period payment using the formula = [ 22000*0.00667*(1+0.00667)^96] / [(1+0.00667 ^96 -1]
Monthly payment =                                                                311.01
Annual cash out flow                                                             3,732.08

Semi annual payment and annual cash outflows are:

Semi annual payment = [P * R * (1+R)^N ] / [(1+R)^N -1]
Using the formula:
Loan amount P                                                           22,000.00
Rate of interest per period:
Annual rate of interest 8.000%
Frequency of payment = Once in 6 month period
Numer of payments in a year = 12/6 = 2
Rate of interest per period R 0.08 /2 = 4.0000%
Total number of payments:
Frequency of payment = Once in 6 month period
Number of years of loan repayment =                                                                          8
Total number of payments N 8*2 = 16
Period payment using the formula = [ 22000*0.04*(1+0.04)^16] / [(1+0.04 ^16 -1]
Semi annual payment =                                                             1,888.04
Annual cash out flow                                                             3,776.08

semi annual payment results in higher annual cash outflow because increase in time to payment increases interest payment. Monthly payment results in lesser annual cash outflow because earlier the amount paid back lesser the interest on outstanding loan amount.

Total payments under semi-annual payments = $1,888.04 X 16 = $30,208.64

please rate the answer.


Related Solutions

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....
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...
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...
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...
Mary and Sam are the only two growers who provide organically grown corn to a local...
Mary and Sam are the only two growers who provide organically grown corn to a local grocery store. They know that if they cooperated and produced less corn, they could raise the price of the corn. If they work independently, they will each earn $100. If they decide to work together and both lower their output, they can each earn $150. If one person lowers output and the other does not, the person who lowers output will earn $0 and...
This assignment requires using the Excel add-in called Solver. Sam manufacturing company produces two types of...
This assignment requires using the Excel add-in called Solver. Sam manufacturing company produces two types of tires: Economy tires and Premium tires. The manufacturing time and the profit contribution per tire are given in the following table. Answer the following assuming that the company is interested in maximizing the total profit contribution. What is the linear programming model for this problem? Develop a spreadsheet model and find the optimal solution using Excel Solver. How many tires of each model should...
Research and identify two professional opportunities within your organization or in your local area that you...
Research and identify two professional opportunities within your organization or in your local area that you can act upon to improve own self and social awareness. Provide details of each opportunity that you identify eg: location,time,duration,etc
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT