Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

thanks for helping M2LE2 Hand-In Assignment Instructions: Open a new word processing document and provide your response to the problem presented below. You may use

image text in transcribed

thanks for helping

image text in transcribed
M2LE2 Hand-In Assignment Instructions: Open a new word processing document and provide your response to the problem presented below. You may use any of the calculation methods introduced in this LE to support your work. Be sure to show your work ciean'y. Remember to save your work when done, as you will be submitting it to 1mm teacher for evaluation. If you use the spreadsheet, include screen captures (in print or electronic form) of the spreadsheet. The Problem: Here is important information: Part A: You want to explore the costs of renting and buying a property that you're interested in during the year 2010. You have it narrowed down to a few homes in the same neighbourhood. All homes remain at the same value annually, and have a frontage of 50 feet. Each home will cost $15 000 for any additional costs. You can afford payments up to $875/month and have $19 000 saved as a down payment. The bank gives you three amortization options: a 15 years at 2.1% . 20 years at 2.1% . 25 years at 2.1% Choose an amortization period you want and find the maximum value of the home that you can afford with that option. Part B: The municipal mill rate in the neighbourhood is 22.375 mills. There is an educational mill rate of 11.35 mills. The following list is the municipalities planned local improvement costs for the next 25 years in that neighbourhood: Boulevard Reconstruction Water Renewal 4794 h Concrete Street Paving Land Drainage System 4 >4 5 l y/ l . . . . l . . . . _ l l . l 2010 2015 2020 2025 2030 2035 M2LE2 Hand-in Assignment Questions - 1 . Boulevard reconstruction costs $4.25/foot 0 Water renewal costs $1.90/foot 0 Concrete street paving costs $2.65/foot - Land drainage system costs $6.10/foot Find the total cost of the property taxes over the amortization period chosen. Part C: The rent for any home in the neighbourhood is 30% higher than the monthly mortgage payment for the rst year. Rent will increase by 1.5% annually after that. You can invest any money saved by renting in an account that pays 3.2%. With the given information, compare the cost of buying and renting the home that fits your financial needs over the amortization period chosen. Then, make a final decision whether to rent or buy the home and give your most important reason for the decision

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

Recommended Textbook for

Introductory Real Analysis

Authors: A N Kolmogorov, S V Fomin, Richard A Silverman

1st Edition

0486134741, 9780486134741

More Books

Students also viewed these Mathematics questions

Question

600 lb 20 0.5 ft 30 30 5 ft

Answered: 1 week ago

Question

Mortality rate

Answered: 1 week ago

Question

Armed conflicts.

Answered: 1 week ago