After reviewing the compounding model your kindergartener has a follow-up question about effective annual rates. She figures with more frequent compounding the effective annual rate cannot be 3% for all the compounding options. Calculate the effective annual rate for each of the compounding options using a function. Round three decimal places. Annual at 3% Semi-annual at 3.022% Quarterly at 3.034% Monthly at 3.042%

Assume you are preparing to move into a new neighborhood. You are considering renting or buying. Divide your team into two groups. Requirements Group 1 will analyze the renting option. A suitable rental is available for $500 per month, and you expect rent to increase by $50 per month per year. Prepare a schedule showing rent payments for the next 15 years. To simplify the problem, assume rent is paid annually. Using 5% as the discount rate, determine the present value of the rent payments. Round present value amounts to the nearest dollar. Group 2 will analyze the buying option. A suitable purchase will require financing $105,876 at 5%. Annual payments for 15 years will be $10,200 (annual payments assumed to simplify the problem). Calculate the present value of the payments. Additionally, using Excel with appropriate formulas, prepare a payment schedule with the following columns (year 1 is completed as an example): After each group has prepared its schedule, meet as a full team to…

Find the following values using the equations and then a financial calculator. Compounding/discounting occurs annually. Do not round intermediate calculations. Round your answers to the nearest cent. a. An initial $800 compounded for 1 year at 9%. $ b. An initial $800 compounded for 2 years at 9%. $ c. The present value of $800 due in 1 year at a discount rate of 9%. $ d. The present value of $800 due in 2 years at a discount rate of 9%. $

1. Exercise One: Jessica decides to take a $25,000 to help her cover her tuition expenses. The tenor of the loan is 10 years, and the interest rate is 6.75%. Repayments will be made on a monthly frequency. Based on the aforementioned information, and the material covered in class, (a) use the PMT function in Excel to find the fixed total payment, (b) verify your answer from (a) by programming the present value annuity formula as shown in class, (c) create an amortization schedule for this loan, (d) create a bar chart showing the Fixed Total Payment, Interest Paid, and Principal Paid.

You need a loan of ​$175,000 to buy a home. Calculate your monthly payments and total closing costs for each choice below. Briefly discuss how you would decide between the two choices.   Choice​ 1: 30​-year fixed rate at 7​% with closing costs of ​$1400 and no points. Choice​ 2: 30​-year fixed rate at 6.5​% with closing costs of ​$1400 and 2 points.   What is the monthly payment for choice 1?  What is the monthy Payment for choice 2?  What is the closing paymennt for choice 1?  What is the closing paymennt for choice 2?

magine you borrow $500 from your roommate, agreeing to pay her back $500 plus 12 percent nominal interest in one year. Assume inflation over the life of the contract is expected to be 5.94 percent. What is the total dollar amount you will have to pay her back in a year? What approximate percentage of the interest payment is the result of the real rate of interest? Use the simplified Fisher equation. (Do not round intermediate calculations. Round answers to 2 decimal places, e.g. 17.54.)Excel Template(Note: This template includes the problem statement as it appears in your textbook. The problem assigned to you here may have different values. When using this template, copy the problem statement from this screen for easy reference to the values you’ve been given here, and be sure to update any values that may have been pre-entered in the template based on the textbook version of the problem.) Total dollar amount   $enter a dollar amount rounded to 2 decimal places    Approximate…

You volunteer on a local fire department and are asked to help in the purchase of a new fire engine. You seek out a loan from a bank in which they state the annual interest on the loan would be 10%. However, the interest compounds once per quarter. What is the effective annual percentage rate (APR) if you select this loan?     10.38%     10%     15.1%     1.11%

Harriet Marcus is concerned about the financing of a home. She saw a small cottage that sells for $74,000. Assuming that she puts 20% down, what will be her monthly payment and the total cost of interest over the cost of the loan for each assumption? (Use the Table 15.1) Note: Do not round intermediate calculations. Round your answers to the nearest cent.   Monthly payment Total cost of interest a. 25 Years, 4.75% $337.51 $42,053.00 b.25 Years, 5.25%     c. 25 Years, 5.50% $363.54 $49,862.00 d. 25 Years, 5.75%     e. What is the savings in interest cost between 4.75% and 5.75%? Note: Round your answer to the nearest dollar amount. Interest cost: f. If Harriet uses 30 years instead of 25 for both 4.75% and 5.75%, what is the difference in interest? Note: Use 360 days a year. Round your answer to the nearest dollar amount. Interest difference:   TABLE 15.1 Amortization table (mortgage principal and interest per $1,000) Rate Interest Only 10 Year 15 Year 20 Year 25 Year…

K Wei-Jen needs to borrow $5000. She can borrow from a finance company at 6.90% add-on interest for 4 years. Or she can borrow from a credit union (48 monthly payments of $134.14 each.) Find each APR and determine the better choice. 10.0 APR 10.5 APR 11.0 APR 11.5 APR 12.0 APR # of monthly payments (n) 24 36 48 60 10.75 16.16 21.74 27.48 11.30 17.01 22.90 28.96 11.86 17.86 24.06 30.45 12.42 18.71 25.23 31.96 Use the table to find the APR for the finance company loan.% (Round to the nearest half percent.) Use the table to find the APR for the credit union loan. % (Round to the nearest half percent.) Which is the better choice? 12.98 19.57 26.40 33.47 12.5 APR 13.54 20.43 27.58 34.99 13.0 APR 14.10 21.30 28.77 36.52

You need a loan of $195,000 to buy a home. Calculate your monthly payments and total closing costs for each choice below. Briefly discuss how you would decide between the two choices. Choice 1: 30-year fixed rate at 6 % with closing costs of $1800 and no points. Choice 2:30-year fixed rate at 5.5% with closing costs of $1800 and 2 points. What is the monthly payment for choice 1? What is the monthly payment for choice 2? What is the best option. Why is it the best option?