Is there a formula to quickly calculate amortized interest? I know how to do it for...

Is there a formula to quickly calculate amortized interest? I know how to do it for each individual payment period (interest= [principle amount]x[interest rate]) and subtracting the amount of the payment that goes towards the principle, and doing it over and over again. However, this process takes too long once you get more payment periods. I am trying to answer the following question:

Q: You have paid for 20 years of your 30 year mortgage and make monthly payments of $2,545. Assuming the APR on the loan is 6.6% per year, compounded monthly, a) how much would you need today to pay off the remaining balance on the mortgage? Based on this information, b) what was the amount of the original mortgage?

So far, I have calculated the original mortgage to be $398,491.33 (is this right? I used the present value of an annuity formula- not sure if this is correct process). I am struggling with part a.

Expert Solution

There will be 10 years left on the mortgage i.e., 12*10 payments

Loan left=Present Value of payments=Present Value of ordinary annuity=Annuity/(r)*(1-1/(1+r)^n)=2545/(6.6%/12)*(1-1/(1+6.6%/12)^(12*10))
=223133.1805

Amanda K answered 2 years ago

How do I calculate finding I/Y manually, I know how to BAII Plus it?

How do I calculate finding I/Y manually, I know how to BAII Plus it? •Debt: •1 million bonds outstanding •$1000.00 face value •Current price = $1100.00 •Coupon rate = 9%, semiannual coupons •15 years to maturity Tax Rate is 40% I know the set up and answer is -1100 = 45(PVIFA, I/Y, 30) + 1000(PVIF, I/Y, 30) I/Y = 3.9268 x 2 = 7.85%

how do I calculate the standard deviation of the stock returns by hand using this formula?...

how do I calculate the standard deviation of the stock returns by hand using this formula? Please show equations Returns KR -0.028046707 -0.00137424 -0.073959399 0.023774212 0.000725709 0.093908593 0.040437549 -0.036635855 -0.013787899 -0.001010467 -0.016520524 0.013027037 -0.07275805 0.006569397 0.002900627 0.027838008 0.035174196 -0.044512422 -0.001778114 -0.008550123 0.060007208 -0.028523993 -0.017531506 -0.126695243 -0.004495254 -0.000821074 0.010682065 -0.028455365 0.074058593 0.004285193 -0.030256065 0.029600028 0.003496525 -0.062330684 -0.015213977 -0.03836428 0.049101291 0.013790208 -0.083264582 -0.023830978 0.001842499 0.00643668 -0.009136514 -0.009681867 0.035381773 0.048561093 -0.028301859 0.034986635 0.016745341 0.043074367 0.061943277

how do i calculate the ETF Value(in $). HOW DO I CALCULATE WHAT FOR THIS ANSWER?...

how do i calculate the ETF Value(in $). HOW DO I CALCULATE WHAT FOR THIS ANSWER? Day Value of Index Index Daily Change ETF Expected % Change ETF Value (in $) 1 100 100 2 110 10.0 20 120.00 3 100 -9.1 -18.2 98.16 4 90 -10.1 -20.2 78.33

How do I do independent t test on the data set below and how do I know...

How do I do independent t test on the data set below and how do I know if its pooled t test or unrolled t test? Health question for reference: to what extend does the age of MI patients vary by gender Standard deviation: male = 13.944 female= 13.939 mean: male 65.353 female=73.628 Male female 65 88 77 81 78 82 76 66 40 81 83 73 58 64 43 53 39 69 66 67 61 89 49 85 85 81...

What formula do I use to calculate the Effective Cost of Borrowing (IRR in excel) for...

What formula do I use to calculate the Effective Cost of Borrowing (IRR in excel) for the following cash flows. Years Cashflows 0 $ (94,000.00) 1 884.91 2 833.33 3 786.50 4 744.30 5 706.57 6 698.12 7 705.77 8 712.64 9 718.74 10 724.03 11 728.49 12 732.11 13 734.87 14 736.76 15 737.74 ECB IRR= To calculate ECB, IRR function has to be used using annual payments for cash-flows. However the payments have to be calculated monthly and...

How do I find a good short term stock to invest in? How do I know...

How do I find a good short term stock to invest in? How do I know if a penny stock will go up? A good long term stock to invest in? What do I need to look at?

How do I know that steam distillation finished?

How to calculate overall fuel economy of hydraulic hybrid vehicle? Know that fuel economy formula is...

How to calculate overall fuel economy of hydraulic hybrid vehicle? Know that fuel economy formula is litre per used over distance travelled. How to calculate the fuel used for both ICE and hydraulic system

I wonder how is the FORMULA TO CALCULATE % change in sales, Projected total assets, and...

I wonder how is the FORMULA TO CALCULATE % change in sales, Projected total assets, and Projected Current Liabilities! I know the answer but I do not know where does the answer comes from. I NEED A FORMULA. NOT JUST A NUMBER Here is the question and answer : XYZ has the following financial information for 2018: Sales = $2M, Net Inc. = $0.4M, Div. = $0.1M C.A. = $0.4M, F.A. = $3.6M C.L. = $0.2M, LTD = $1M, C.S....

I have the formulas for how to calculate ROI, Margin and Turnover. But I don't know...

I have the formulas for how to calculate ROI, Margin and Turnover. But I don't know if I am using the right numbers and it gets frustrating. A worked out calculation for each would really be helpful so I know what numbers from what years you plugged in. Your time is valuable and would really appreciate the help. If the response is correct, I would not mind giving a like! Return on Investment, Margin, Turnover Ready Electronics is facing stiff...

Question