Question: need detailed step by step explanation for final payment show work in Excel or any spread sheet thanks in advance The balance on a mortgage

need detailed step by step explanation for final payment show work

need detailed step by step explanation for final payment show work in Excel or any spread sheet thanks in advance

The balance on a mortgage was $43,700 and an interest rate of 4.50% compounded semi-annually was charged for the remaining 5-year term. Monthly payments were made to settle the mortgage. a. Calculate the size of the monthly payments. Round up to the next whole number b. If the monthly payments were set at $964, how long would it take to pay off the mortgage? years months Express the answer in years and months, rounded to the next payment period c. If the monthly payments were set at $964, calculate the size of the final payment. Round to the nearest cent

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

A steel wheel has a diameter of 840 mm and a cross section as shown in the figure. Determine the total mass of the wheel if = 5 Mg/m 3 . 100 mm A 30 mm- 60 mm 420 mm 250 mm 30 mm 840 mm 80 mm...

i have posted first assignment then the preview steps. I would appreciate a detailed step by step explanation of each of the preview steps. your help is very much appreciated F2 General Merge &...

IfyouhaveplayedaSimulationcalledProBankerIneedhelpansweringthesequestionsassoonaspossible from the pro bankerassignment attachment..please use spreadsheet and players manual for reference. Need...

I've attached the questions as a word file. Thanks! c04AccrualAccountingConcepts.qxd 8/3/10 1:50 PM Page 162 chapter 4 ACCRUAL ACCOUNTING CONCEPTS the navigator Scan Study Objectives Read Feature...

I've attached the question as a word file, thanks! c04AccrualAccountingConcepts.qxd 8/3/10 1:50 PM Page 162 chapter 4 ACCRUAL ACCOUNTING CONCEPTS the navigator Scan Study Objectives Read Feature...

I've attached the questions as a word file. Thanks! c04AccrualAccountingConcepts.qxd 8/3/10 1:50 PM Page 162 chapter 4 ACCRUAL ACCOUNTING CONCEPTS the navigator Scan Study Objectives Read Feature...

please help me to find the answer for part 1, part3 and part4 Queensland University of Technology QUT Business School School of Accountancy AYB 339 Accountancy Capstone Integrated Case Study Semester...

just only 2 questions ,please read the requirment word by word and be careful about the style of the reference(APA) , file 3.1 is for question 2..BTW,please focus the every step FINANCE SPOTLIGHT...

L O 0 3 - 0 2 Explain and apply the revenue and expense recognition principles.Skip t o question [ T h e following information applies t o the questions displayed below. ] I n this module, you will...

I have included the question as a word file. I also added text from the chapter in case it might help. c04AccrualAccountingConcepts.qxd 8/3/10 1:50 PM Page 162 chapter 4 ACCRUAL ACCOUNTING CONCEPTS...

Assume that Canadian wheat sells for $100 per bushel, Russianwheat sells for 1600 rubles per bushel, and the nominal exchangerate is 4 rubles per dollar. a) Explain how you could make a profit...

At a minimum, you need one quantitative (numerical) variable and one qualitative (categorical) variable (with at least two levels). Get some data from the source of your choice (at least two columns...

View Policies Current Attempt in Progress Kingbird Inc. reported the following information at the end of its 2 0 2 2 fiscal year. \ begin { tabular } { | c | c | c | } \ hline \ multicolumn { 3 } { |...

10) For a bond that pays cash interest (i.e., not a zero coupon bond), YTM is (a) always equal to the coupon rate (b) always equal to the current yield (c) is always less than the coupon rate (d) can...

6. Search YouTube for a segment with a speaker giving a speech or visit TED talks (the topic does not matter). Turn off the volume so you can only see (not hear) the speech. Analyze the physical...

6. Pick a general topic and try to come up with several different attention getters for that topic. Heres an example for the topic dogs: c Tell a funny story about your dog. c Did you know that the...

5. Establishing a relationship with the audience is important when giving a speech. Make a list of all of the possible members of your audience. How do you plan to connect with all members of the...