Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribedimage text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions

Question

develop a Four Links Analysis of the organisations co-operators;

Answered: 1 week ago