Question: Hello!, Quick question. I just finished Question 2. I just want somebody to confirm if what I'm doing is correct. For term nunber 360, I

Hello!, Quick question. I just finished Question 2. I just want somebody to confirm if what I'm doing is correct. For term nunber 360, I have a balance of 0. Am I missing something from the question? Am I putting any numbers into the wrong cell for home value, Interest, Term, and PMT? Thanks

If letters are to small for that picture, here is the question:

Question : Find a home in the Morgantown area. You are expected to earn the average income from your degree (assume no more than $65,000. You may use 33% of your after-tax income to fund your mortgage expenses. First determine the amount of mortgage you can afford, then find a house in Morgantown which fits the bill. Compute the mortgage payment using 4.25% as the prevailing rate. Construct an amortization table and upload it in your response. Include the address of your selected house and other prevalent information. Save your file with the following naming structure

Hello!, Quick question. I just finished Question 2. I just want somebodyto confirm if what I'm doing is correct. For term nunber 360,

Question 2 10 points Answwer dere 33% af your after-tax incorre to find your mortgage exp ation table end upload It in your response. Incu Firid a horne in the Margantown aresa. Yau are expected to ear the average incame fro yur degree (assurne rio more than $85,000. You ay se me t sng 4.25% 88 the preveiling ate. Construct an e mortiza perses First deteriine the anount ofmarlgage yau can loro, t en tind a nouse n Mo anto m which tits te bill Compute tne mortgege pe nforrmatian. Save ynur file with tha fnlaiig strurturc dethe address ot your 8elected house and other ore alent Save your fie wihrtanouwnion tits the bil. Compute the AutoSave OFF Home InsertDraw Page Layout Formulas Data Review View Cut Format L" Calibri (Body) Wrap Text Paste a Merge & Cer M14 Home Value nterest Term PMT End 265000 4% Term Int Prine Pay 265000 1,303.64 938.54 365.10 $264,634.90 2 $264,634.90 $1,303.64 937.25 366.39 $264,268.51 3 $264,268.51 $1,303.64 935.95 $367.69 $263,900.82 4 $263,900.82 1,303.64 934.65 368.99 $263,531.83 5 $263,531.83 $1,303.64 933.34 $370.30 $263,161.53 6 $263,161.53 $1,303.64 932.03 $371.61 $262,789.92 7 $262,789.92 $1,303.64 930.71 372.93 $262,416.99 8 $262,416.99 $1,303.64 929.39 374.25 $262,042.74 9 $262,042.74 $1,303.64 928.07 $375.57 $261,667.17 10 $261,667.17 $1,303.64 926.74 376.90 $261,290.27 11 $261,290.27 $1,303.64 925.40 378.24 $260,912.03 12 $260,912.03 $1,303.64 924.06 379.58 $260,532.45 13 $260,532.45 $1,303.64 922.72 $380.92 $260,151.53 14 $260,151.53 $1,303.64 921.37 382.27 $259,769.26 15 $259,769.26 $1,303.64 920.02 $383.62 $259,385.64 16 $259,385.64 1,303.64 918.66 $384.98 $259,000.65 17 $259,000.65 $1,303.64 917.29 386.35 $258,614.31 18 $258,614.31 $1,303.64 915.93 $387.72 $258,226.59 19 $258,226.59 $1,303.64 914.55 $389.09 $257,837.50 20 $257,837.50 $1,303.64 913.17 390.47 $257,447.04 21 $257,447.04 51,303.64 911.79 $391.85 $257,055.19 22 $257,055.19 $1,303.64 910.40 393.24 $256,661.95 23 $256,661.95 1,303.64 909.01 394.63 $256,267.32 24 $256,267.32 $1,303.64 907.61 $396.03 $255,871.29 25 $255,871.29 $1,303.64 906.21 397.43 $255,473.86 26 $255,473.86 $1,303.64904.80$398.84 $255,075.03 27 $255,075.03 1,303.64 903.39 $400.25 $254,674.78 28 $254,674.78 $1,303.64 901.97401.67 $254,273.11 29 $254,273.11 $1,303.64 900.55 $403.09 $253,870.02 30 $253,870.02 $1,303.64 899.12 $404.52 $253,465.50 31 $253,465.50$1,303.64 897.69 405.95 $253,059.55 32 $253,059.55 $1,303.64 896.25 $407.39 $252,652.16 33 $252,652.16 $1,303.64 894.81 408.83 $252,243.33 34 $252,243.33 $1,303.64 893.36 $410.28 $251,833.05 35 $251,833.05 $1,303.64 891.91 $411.73 $251,421.32 36 $251,421.32 $1,303.64 890.45 $413.19 $251,008.13 37 $251,008.13 $1,303.64 888.99 $414.65 $250,593.48 38 $250,593.48 $1,303.64 887.52 $416.12 $250,177.36 39 $250,177.3 1,303.64 886.04 417.60 $249,759.76 40 $249,759.76 $1,303.64 884.57 $419.07 $249,340.68 41 $249,340.68 $1,303.64 883.08 $420.56 $248,920.13 42 $248,920.13 $1,303.64 881.59 422.05 $248,498.08 43 $248,498.08 $1,303.64 880.10 $423.54 $248,074.53 44 $248,074.53 1,303.64 878.60 $425.04 $247,649.49 45 $247,649.49 $1,303.64 877.09 $426.55 $247,222.94 46 $247,222.94 $1,303.64 875.58 $428.06 $246,794.88 47 $246,794.88 $1,303.64 874.07 $429.58 $246,365.31 48 $246,365.31 $1,303.64 872.54 $431.10 $245,934.21 49 $245,934.21 $1,303.64 871.02 432.62 $245,501.59 50 $245,501.59 $1,303.64 869.48 $434.16 $245,067.43 51 $245,067.43 $1,303.64 867.95 $435.69 $244,631.74 52 $244.631.74 $1303.64866.40S437 24$244 194.50 $1,303.64 15 25 29 30 38 46 50 Mortgage

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!