Mr. and Mrs. Thompson purchased a condominium. It was financed with a $185,500, 30-year, 3.875% compounded monthly mortgage.
Please show all your work if possible and label the answer. Thank you.
Calculating Monthly Payment,
Using TVM Calculation,
PMT = [PV = 185,500, FV = 0, N = 360, I = 0.03875/12]
PMT = $872.29
Interest Paid = 872.29(360) - 185,500
Interest Paid = $128,524.40
Mr. and Mrs. Thompson purchased a condominium. It was financed with a $185,500, 30-year, 3.875% compounded...
Your professor contributes $625 at the end of each month
(including some matching funds from the college) to the CREF Stock
Fund.
Please show your all work if possible and label the answer.
Thank you.
4. (4%) Assume that the economy has gotten better by the end of the first 15 years and, from that time on, the fund returns 8.75%, compounded monthly. Since the professor's salary has risen over the first 15 years, he can now contribute $1000 per...
Now do an Amortization Schedule Bank A's offer is 15 years at 3.5% interest compounded monthly. Determine your monthly payment. Write in a complete sentence. Fill in what you would put on the calculator to show work. Calculator APPS / Finance / TVM Solver N = 180 I% = 3.5 PV = -1175000 PMT = Solve FV = 0 P/Y = 12 C/Y = 12 PMT: end/begin Alpha Solve My monthly Payments would be $8,399.87 What is the total amount...
Assume that you have a 30 year fully-amortized fixed rate mortgage for your home. Your loan amount is $300,000 with a 3% annual interest rate. After 28 years, you would like to sell the property. What is your loan balance at the end of 28 years? Assume that you have a 30 year fully-amortized fixed rate mortgage for your home. Your loan amount is $300,000 with a 3% annual interest rate and your balloon payment is $50,000. What is your...
Please provide the formulas
for excel as well
Excel File Edit View Insert Format Tools Data Window Hel ACFI 385 Excel Project Winter 2019(1) (2).xlsx 1 00% ▼ |Search in Sheet Home Layout Tables Charts SmartArt Formulas Data Review Edit Font Aignme Fill ▼ Verdana Wrap TextCeneral Good Conditional Check Cell Insert Delete Format Themes Aa 41 ; * O ( Analyze the following scenarios that will require you to compute either the present value, future value, and/or the a...