You may not buy a home or need a mortgage for several years, but it's important...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You may not buy a home or need a mortgage for several years, but it's important to understand some of what that entails. Complete this worksheet with your first home in mind. I hope to buy my home in (or around) the year I very roughly estimate it to cost S Use what you learned in the Home Buying lectures to fill in the blanks below. The mortgage lender would prefer my down payment to be %, which would be S My closing costs could be as much as S Between the down payment and closing costs above, I would need S in cash up-front. If I can't afford to pay the full down payment up front, I could... (list 2 options for reducing this requirement). 1. 2. % of the price of the home, which would be Assuming I can pay the full down payment above, I would still need a mortgage of S According to bankrate.com. (input the name of the lender) is currently offering a % and a monthly payment of $ 30 year, fixed interest mortgage with an APR of Based upon the value of the home I listed above, my annual property taxes would roughly be S (assuming a tax rate of 2.38%). Assuming my home insurance will cost $2,000 annually, fill in your monthly PITI below: P&I S IS Total PITI S TS Lenders prefer my PITI to be less than gross monthly income needs to be S $ to be approved for this mortgage. If I pay the required monthly mortgage payment over 30 years, I will pay a total of $ in interest (use bankrate.com's Amortization Calculator). If I pay an additional $100 towards on top of my required monthly mortgage payment each month, I'll instead pay a total of S in interest, causing me to save $ and allow me to repay my mortgage in only Example: Paying only the required payment Monthly Payments $836.03 Mortgage amount $145.000 Mortgage term in years Term in months 340 Interest rate per year 45 HIDE EXTRA PAYMENTS $0 $0 % $0 Dec 2047 Jan 2048 Feb 2048 Mar 2048 Apr 2048 May 2048 WAS Jun 2048 Jul 2048 Guantes Aug 2048 Sep 2048 Oct 2048 Nov 2048 CALCULATE Total Principal Paid Total Interest Paid Caculate the impact of extra payments using any combination of the inputs below. To see your new estimated payondale, cick Show amortuaron schedule nk above to your monty mortgage payment as a one-time mortgage payment in TODAY'S RATES as an extra yearly mortgage payment occuring every $836.03 $799.3 $36.72 $036.03 $802.31 $33.72 $836.03 $805.32 $30.71 $836.03 $808.34 $27.69 262 $836.03 $811.37 $24.66 C P $836.03 $814.41 $21.62 T C $817.46 $18.57 $836.03 TAS TORT $836.03 $820.53 $15.50 ENPRESAR $836.03 wwwwww PER $823.61 $12.42 $836.03 $826.70 $9.34 $836.03 $829.80 $6.24 $836.03 $832.91 $3.12 years. Show amortization schedule December $185.000 $135.971.07 % of my gross monthly income, and so I estimate that my and my gross annual income needs to be December ↓ APPLY EXTRA PAYMENTS $135,767.48 $135.901.20 $135.831.91 $135.859.61 $135,884.27 $135,905.89 $135,924.46 $135,939.96 www. $135,952.38 $135,961.72 $135,967.95 $135,971.07 2018 ↓ $8,992.74 $8,190.43 $7.385 11 $6.576.78 $5,765.41 $4.951.00 PER $4,133.54 P $3,313.01. $2,489.40 $1,662.70 $832.91 $0.00 Example: Paying an extra $100 each month Mortgage amount 8165,000 Mortgage term in years 30 Or Term in months 360 interest rate per year 4.5 HIDE EXTRA PAYMENTS $0 $0 N Feb 2042 Mar 2042 Apr 2042 May 2042 Jun 2042 Rese Jul 2042 Anten Aug 2042 Sep 2042 Oct 2042 Nov 2042 Dec 2012 Jan 2043 CALCULATE Caculate the impact of extra payments using any combination of the inputs below. To see your new estimated payoff date, click Show amortization schedule link above. $100 to your monthly mortgage payment Total Principal Paid Total Interest Paid Monthly Payments as a one-time management in $836.03 $936.03 $898.15 $37.88 $936.03 $901.52 $34.51 $936.03 $31.13 $936.00 $908 29 $27.74 $936.03 $911.70 $24.33 $936.03 $915.12 $20.91 $936.03 $918 55 $17.48 $936.03 $921.99 $14.04 $936.03 $925.45 $10.58 $936.03 $928 92 $7.11 $936.03 $932 40 $3.63 $34.63 $34.50 $0.13 $904 90 TODAY'S RATES as an extra yearly mangage payment occuring every Show amortization schedule December $165.000 $105.547.52 $105.355.93 $105.390.44 APPLY EXTRA PAYMENTS $105.421.58 $105,449.31 $105.473.65 $105.494 56 $105.494.56 $105.512.04 $105.526.08 $105.536.66 $105.543.77 $105.547.39 $105,547.52 December + 2018 A ↓ $9,203.35 $8.301.83 $7,396.93 $6.488.64 $5.576.94 $4,661.82 $3,743.27 $2.821.20 $1.895.83 $966.91 $34.50 $0.00 You may not buy a home or need a mortgage for several years, but it's important to understand some of what that entails. Complete this worksheet with your first home in mind. I hope to buy my home in (or around) the year I very roughly estimate it to cost S Use what you learned in the Home Buying lectures to fill in the blanks below. The mortgage lender would prefer my down payment to be %, which would be S My closing costs could be as much as S Between the down payment and closing costs above, I would need S in cash up-front. If I can't afford to pay the full down payment up front, I could... (list 2 options for reducing this requirement). 1. 2. % of the price of the home, which would be Assuming I can pay the full down payment above, I would still need a mortgage of S According to bankrate.com. (input the name of the lender) is currently offering a % and a monthly payment of $ 30 year, fixed interest mortgage with an APR of Based upon the value of the home I listed above, my annual property taxes would roughly be S (assuming a tax rate of 2.38%). Assuming my home insurance will cost $2,000 annually, fill in your monthly PITI below: P&I S IS Total PITI S TS Lenders prefer my PITI to be less than gross monthly income needs to be S $ to be approved for this mortgage. If I pay the required monthly mortgage payment over 30 years, I will pay a total of $ in interest (use bankrate.com's Amortization Calculator). If I pay an additional $100 towards on top of my required monthly mortgage payment each month, I'll instead pay a total of S in interest, causing me to save $ and allow me to repay my mortgage in only Example: Paying only the required payment Monthly Payments $836.03 Mortgage amount $145.000 Mortgage term in years Term in months 340 Interest rate per year 45 HIDE EXTRA PAYMENTS $0 $0 % $0 Dec 2047 Jan 2048 Feb 2048 Mar 2048 Apr 2048 May 2048 WAS Jun 2048 Jul 2048 Guantes Aug 2048 Sep 2048 Oct 2048 Nov 2048 CALCULATE Total Principal Paid Total Interest Paid Caculate the impact of extra payments using any combination of the inputs below. To see your new estimated payondale, cick Show amortuaron schedule nk above to your monty mortgage payment as a one-time mortgage payment in TODAY'S RATES as an extra yearly mortgage payment occuring every $836.03 $799.3 $36.72 $036.03 $802.31 $33.72 $836.03 $805.32 $30.71 $836.03 $808.34 $27.69 262 $836.03 $811.37 $24.66 C P $836.03 $814.41 $21.62 T C $817.46 $18.57 $836.03 TAS TORT $836.03 $820.53 $15.50 ENPRESAR $836.03 wwwwww PER $823.61 $12.42 $836.03 $826.70 $9.34 $836.03 $829.80 $6.24 $836.03 $832.91 $3.12 years. Show amortization schedule December $185.000 $135.971.07 % of my gross monthly income, and so I estimate that my and my gross annual income needs to be December ↓ APPLY EXTRA PAYMENTS $135,767.48 $135.901.20 $135.831.91 $135.859.61 $135,884.27 $135,905.89 $135,924.46 $135,939.96 www. $135,952.38 $135,961.72 $135,967.95 $135,971.07 2018 ↓ $8,992.74 $8,190.43 $7.385 11 $6.576.78 $5,765.41 $4.951.00 PER $4,133.54 P $3,313.01. $2,489.40 $1,662.70 $832.91 $0.00 Example: Paying an extra $100 each month Mortgage amount 8165,000 Mortgage term in years 30 Or Term in months 360 interest rate per year 4.5 HIDE EXTRA PAYMENTS $0 $0 N Feb 2042 Mar 2042 Apr 2042 May 2042 Jun 2042 Rese Jul 2042 Anten Aug 2042 Sep 2042 Oct 2042 Nov 2042 Dec 2012 Jan 2043 CALCULATE Caculate the impact of extra payments using any combination of the inputs below. To see your new estimated payoff date, click Show amortization schedule link above. $100 to your monthly mortgage payment Total Principal Paid Total Interest Paid Monthly Payments as a one-time management in $836.03 $936.03 $898.15 $37.88 $936.03 $901.52 $34.51 $936.03 $31.13 $936.00 $908 29 $27.74 $936.03 $911.70 $24.33 $936.03 $915.12 $20.91 $936.03 $918 55 $17.48 $936.03 $921.99 $14.04 $936.03 $925.45 $10.58 $936.03 $928 92 $7.11 $936.03 $932 40 $3.63 $34.63 $34.50 $0.13 $904 90 TODAY'S RATES as an extra yearly mangage payment occuring every Show amortization schedule December $165.000 $105.547.52 $105.355.93 $105.390.44 APPLY EXTRA PAYMENTS $105.421.58 $105,449.31 $105.473.65 $105.494 56 $105.494.56 $105.512.04 $105.526.08 $105.536.66 $105.543.77 $105.547.39 $105,547.52 December + 2018 A ↓ $9,203.35 $8.301.83 $7,396.93 $6.488.64 $5.576.94 $4,661.82 $3,743.27 $2.821.20 $1.895.83 $966.91 $34.50 $0.00
Expert Answer:
Answer rating: 100% (QA)
Based on the information provided in the worksheet here are some calculations and conclusions The ho... View the full answer
Related Book For
Accounting Information Systems basic concepts and current issues
ISBN: 978-0078025334
3rd edition
Authors: Robert Hurt
Posted Date:
Students also viewed these finance questions
-
Product and price descriptions for three products from three different categories are given below. You can choose one Product (Product 1, 2, OR 3) and create at least TWO segmentation profiles for...
-
All tax calculations should be based on the 2020 Tax Rate Schedules. Figures should be rounded to the nearest dollar. Percentages should be rounded to the nearest whole percentage (e.g., 32% instead...
-
You can choose one of these countries to do a project (Model Nations) England, Germany, France, make sure you read all the attachment and instructions before you start the work make sure you...
-
Write a program that takes as command-line arguments the name of an image file and the pixel coordinates of a rectangle within the image; reads from standard input a list of Color values (represented...
-
List several ways that variances can be used to improve future operations.
-
\(A ightarrow B ightarrow G ightarrow F ightarrow E ightarrow A\) Identify each sequence of vertices from Figure 12.134 as a closed walk, circuit (closed trail), and/or directed cycle (closed path)....
-
Determine the maturity date, interest in 2007 and 2008, and maturity value for a 90-day, 12 percent, $15,000 note from a customer dated December 1, 20x7, assuming a December 31 year-end. Notes...
-
As the lead accountant for a small company, you notice that inventory purchases from a certain vendor have increased dramatically over the past few months, while purchases from all other vendors have...
-
calculus need help asap 6. Let A(x) = / f(f)dt where the graph of f (t) is shown below. Calculate the following. (a) (4 points) A(4) (d ) ( 4 points) 'stelde (b) (4 points) A(7) (e) (4 points) A'(5)...
-
please assist in implementing the included functions. import utils import pilots import os.path # WEATHER FUNCTIONS def bad_visibility(visibility,minimum): """ Returns True if the visibility...
-
An annuity pays $46 per year for 26 years. What is the future value (FV) of this annuity at the end of those 26 years, given that the discount rate is 5%
-
What is a cost baseline? How is it prepared, and how is it used?
-
What are the Seven Basic Tools of Quality? If applicable, describe how you have you used these tools in the workplace.
-
Find an example of a large project that took more than a year to complete. You can ask people at your college, university, or work about a recent project, such as a major fundraising campaign,...
-
How do you create a new client for fixed asset management from within QuickBooks Accountant?
-
What icon is clicked in the Vendors section to record the receipt of inventory and the related bill?
-
Mississippi River Shipyards is considering the replacement of an 8-year-old riveting machine with a new one that will increase earnings before depreciation from $24,000 to $46,000 per year. The new...
-
The power company must generate 100 kW in order to supply an industrial load with 94 kW through a transmission line with 0.09 resistance. If the load power factor is 0.83 lagging, find the...
-
In the previous problem, you identified one relevant element of expectancy theory. Consider each scenario again; fill in the other two elements. Heres an example: Expectancy: Anh studied hard and...
-
a. What is the basic purpose of the acquisition/payment process? b. What steps do companies commonly complete as part of the acquisition/payment process? c. What documents are important in the...
-
As you learned in the chapter, designing and implementing accounting information systems requires judgment and critical thinking. Each chapter will include an exercise like this one to help you...
-
Service Revenue} Melrose Milk Delivery provides weekly gourmet milk delivery to the residents of Nicetown. Melrose charges each customer \(\$ 45\) per week for its milk delivery, and it received...
-
Ratio Analysis} Bari Sports' net sales, average net trade accounts receivable, and net income were \(\$ 7,300,000\), CORNERSTONE 5.5 \(\$ 842,000\), and \(\$ 390,000\), respectively....
-
Service Revenue} \(\mathrm{H} \& \mathrm{R}\) Wholesalers is a retailer providing low-cost, bulk items to small companies. Companies must pay an annual membership fee of \(\$ 100\) to access H\&R's...
Study smarter with the SolutionInn App