Question

3. You have just taken a 30-year mortgage loan for $200,000. The annual percentage rate on the loan is 8%, and payments will be made monthly. Estimate your monthly payments.
0 0
Add a comment Improve this question Transcribed image text
Answer #1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

Home nert Page Layout Formulas Data Review View dd-Ins Cut E AutoSum Calibri ー E ゴWrap Text General ta copy. в 1 프 . Ej-., Δ. : rーー 逻锂函Merge & Center. $, % , 弼,8 Conditional Format eCell Insert Delete Format Paste Sort &Find & Format Painter Formatting as Table Styles2 Clear Clipboard PM146 PJ Font Alignment Number Styles Cells Edting PK PL PM PN PO Pa PR PS PT PU 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 11 1 トーCALCULATOR ( LOAN OPTIONS | pv, fv, annuity 1 CAP STRU VALUE LOAN YEARS RATE METHOD 1 USING FORMULA 200000 30 8% PVA A/(r/m) (1-(1/(1+r/m)mn)) 200000 (A/(0.08/12)) (1-(1/(1+0.08/12)A12*30)) m-NO OF PERIODS IN A YEAR 200000 (A/(0.00666667) (0.90855663) A= 200000*0.00666667/0.90855663 1467.53 METHOD 2 USING EXCEL PMT- $1,467.53 PMT(PO132/12,PO131 12,-PO130) BOX | DILUTION DOLLAR COST AVG MORTGAGE.. EXPO ( Sheet1 . Sheet2. Shell- rences: x261 09:02

Add a comment
Know the answer?
Add Answer to:
3. You have just taken a 30-year mortgage loan for $200,000. The annual percentage rate on...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT