Question: Using fx (function wizard) calculate the monthly payment PV i GIVENS: $50,000.00 0.7500% 48 9.00% 4 PAYMENT (PMT) Using fx $0.00 HINT: You must make
PV i GIVENS: $50,000.00 0.7500% 48 9.00% 4 PAYMENT (PMT) Using fx $0.00 HINT: You must make the PV in the arguments box negative - example -80,000) n r t PMT# PMT AMT PMT to INT PMT to PRIN 1 2 3 4 5 6 3 1 2 23 24 25 26 22 28 7 8 9 10 11 12 13 14 15 375.00 377.81 380.65 383.50 386.38 389.28 392.19 395.14 398.10 401.09 404.09 407.12 410.18 413.25 416.35 419.48 422.62 425.79 428.99 432.20 435.44 438.71 442.00 445.32 448.66 452.02 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Sheet -375.00 -377.81 -380.65 -383.50 -386.38 -389.28 -392.19 -395.14 -398.10 -401.09 404.09 -407.12 -410.18 -413.25 416.35 419.48 -422.62 -425.79 428.99 -432.20 435.44 438.71 442.00 445.32 448.66 452.02 455.41 458 83 46227 465.23 Outstanding Balance 50,000.00 50,375.00 50,752.81 51,133.46 51,516.96 51,903.34 52,292.61 52,684.81 53,079.94 53,478.04 53,879.13 54,283.22 54,690.34 55,100.52 55,513.78 55,930.13 56,349.61 56,772.23 57,198.02 57,627.00 58,059.21 58,494.65 58.933.36 59,375 36 59,820.68 60.269,33 60,721.35 61,126,76 61.635.59 62.097.85 62 563.59 63,03282 63,505.56 16 29 30 32 33 34 35 36 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 19 40 41 45.63 462.27 465,73 43 472.75 72.75 Edit
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
