Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Need help solving these problems thank you Need help getting them in excel format 1. Periodic interest rates. In the following table, fill in the

image text in transcribed

Need help solving these problems thank you Need help getting them in excel format

image text in transcribed 1. Periodic interest rates. In the following table, fill in the periodic rates and the effective annual rates. Period APR Compounding per Year Semiannual 8% 2 Quarterly 9% 4 Monthly 7.5% 12 Daily 4.25 % 365 Periodic Rate Effective Annual Rate a. EAR. What is the EAR of a mortgage that is advertised at 7.75% (APR) over the next twenty years and paid with monthly payments? b. Present value with periodic rates. Let's follow up with Sam Hinds, the dentist, and his remodeling project (Chapter 4, Problem 12). The cost of the equipment for the project is $18,000, and he will finance the purchase with a 7.5% loan over six years. Originally, the loan called for annual payments. Redo the payments based on quarterly payments (four per year) and monthly payments (twelve per year). Compare the annual cash outflows of the two payments. Why does the monthly payment plan have less total cash outflow each year? (See below) c. Future value with periodic rates. Matt Johnson delivers newspapers and is putting away $15.00 every month from his paper route collections. Matt is eight years old and will use the money when he goes to college in ten years. What will be the value of Matt's account in ten years with his monthly payments if he is earning 6% (APR), 8% (APR), or 12% (APR)? 2. Monthly amortization schedule. Sherry and Sam want to purchase a condo at the coast. They will spend $650,000 on the condo and are taking out a loan for the whole amount for the condo for twenty years at 7.0% interest. o a. What is the monthly payment on the mortgage? Construct the amortization of the loan for the twenty years in a spreadsheet to show the interest cost, the principal reduction, and the ending balance each month. o b. Then change the amortization to reflect that after ten years, Sherry and Sam will increase their monthly payment to $7,500 per month. When will they fully repay the mortgage with this increased payment if they apply all the extra dollars above the original payment to the principal? Chapter 4 Problem 12 12. Payments. Sam Hinds, a local dentist, is going to remodel the dental reception area and add two new workstations. He has contacted ADec, and the new equipment and cabinetry will cost $18,000. A-Dec will finance the equipment purchase at 7.5% over a six-year period. What will Hinds have to pay in annual payments for this equipment

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Management Core Concepts

Authors: Raymond M Brooks

2nd edition

132671034, 978-0132671033

More Books

Students also viewed these Finance questions

Question

Why do most small companies use functionally organized departments?

Answered: 1 week ago

Question

Select several interest groups to follow on your LinkedIn account.

Answered: 1 week ago