You are looking to purchase a house valued at $325,000 in the suburbs of Kansas City....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You are looking to purchase a house valued at $325,000 in the suburbs of Kansas City. You decide to pay 20% of the value of the house as down payment and borrow the rest at an APR of 3.20% for 20 years. a) Design an excel sheet that calculates the total payment, principle payment, and interest payment for each month for the entire duration of the loan (20 years). You should have 240 rows in that table to show the payments for each month. b) Assuming that you itemize deductions when you file taxes and are paying 25% marginal tax rate, determine the real cost of owning that house over 20 years. HINT: Determine the present value of the real cost for each month and then sum it over the 240 months. c) Would you be financially better of renting an apartment of similar size in the same neighborhood at a cost of $1000/month and investing your down payment and the difference between mortgage and rent payment in the market? Assume that the rent increases by 2% every year over the 20 years. Make justifiable assumptions for the following Rate of Return on Market Investment Home Maintenance Costs Property Taxes Increase in home value Part c is an open-ended problem and the answers will depend on your assumptions. I expect you to make justifiable assumptions. You are looking to purchase a house valued at $325,000 in the suburbs of Kansas City. You decide to pay 20% of the value of the house as down payment and borrow the rest at an APR of 3.20% for 20 years. a) Design an excel sheet that calculates the total payment, principle payment, and interest payment for each month for the entire duration of the loan (20 years). You should have 240 rows in that table to show the payments for each month. b) Assuming that you itemize deductions when you file taxes and are paying 25% marginal tax rate, determine the real cost of owning that house over 20 years. HINT: Determine the present value of the real cost for each month and then sum it over the 240 months. c) Would you be financially better of renting an apartment of similar size in the same neighborhood at a cost of $1000/month and investing your down payment and the difference between mortgage and rent payment in the market? Assume that the rent increases by 2% every year over the 20 years. Make justifiable assumptions for the following Rate of Return on Market Investment Home Maintenance Costs Property Taxes Increase in home value Part c is an open-ended problem and the answers will depend on your assumptions. I expect you to make justifiable assumptions.
Expert Answer:
Answer rating: 100% (QA)
a Here is an example of how you can set up an Excel sheet to calculate the total payment principal payment and interest payment for each month for the entire duration of the loan 20 years 1 In column ... View the full answer
Related Book For
Posted Date:
Students also viewed these finance questions
-
Her Passion for Fashion Bobbi Jean Donnelly was hardened by her humble beginnings in rural Mississippi. The fourth of six children in a blue-collar working-class family, she spent the early years of...
-
3. Given a differential equation with initial condition dx dt (a) Use Euler's method with h = 0.1 to obtain approximate solutions of x at t = 0.5. (b) Determine the percentage error in x at t = 0.5,...
-
How are financial statements adjusted for exchange rates?
-
Between them, Zillow and Trulia have a very large share of the market for online real estate listings. Real estate brokers who want to advertise their services next to online listings of houses for...
-
In 2011, home prices and mortgage rates dropped so low that in a number of cities the monthly cost of owning a home was less than renting. The following data show the average asking rent for 10...
-
Chase Publishing Company purchased the copyright to a financial textbook for $\$ 25,000$. Although the author thought the book would serve academia for 10 years, the reality is that the typical life...
-
Alpha Company, a project-driven organization, pays its department managers a quarterly bonus that is dependent on two factors: the departmental overhead rate and direct labor dollars. The exact value...
-
ces The most recent financial statements for Crosby, Incorporated, follow. Sales for 2021 are projected to grow by 25 percent. Interest expense will remain constant; the tax rate and the dividend...
-
The isotope technetium-99m is used by doctors to image the skeleton and heart muscles. Fol- lowing injection, the concentration of this isotope decays exponentially in the body. a. Let N(t) represent...
-
A company's share just paid a dividend of $4.00. You expect the dividends to grow by 20% for the next 3 years and then settle down to a constant 2.0% growth. If the required return on the share is...
-
Explain what is meant by induced economic effects and give an example.
-
Suppose an airline increases its average ticket price from JFK to CDG from $435 to $515, and consequently, the number of seats sold drops from 800 to 735: a. What is the price elasticity of demand...
-
Define the economic concept of externality. How might an externality be addressed in the marketplace?
-
What is a sunk cost? Provide an example of a sunk cost in an airline. Should such costs be irrelevant in making future decisions?
-
You are the manager of a firm that sells its product in a competitive market at a price of $50. Your firms cost function is TC = 40 + 5Q2. a. Calculate the profit-maximizing output. b. Calculate the...
-
Which statement is true concerning the liquidation basis of accounting A). Assets remain at book value until liquidated. B). Liabilities are valued at the present value of expected payments, assuming...
-
Two mutually exclusive investment alternatives are being considered. Alternative A requires an initial investment of $20,000 in a machine. Annual operating and maintenance costs are anticipated to be...
-
Explain how a company can incur costs of financial distress without ever going bankrupt. What is the nature of these costs?
-
Key facts and assumptions concerning Kroger Company, at December 12, 2007, appear below. Using this information, answer the questions following. Facts and Assumptions Yield to maturity on long-term...
-
Neptune Biometrics, despite its promising technology, is having difficulty generating profits. Having raised $85 million in an initial public offering of its stock early in the year, the company is...
-
Identify and explain the meaning of the term "strategy."
-
Identify and describe the major features of the Strategic Management model.
-
Identify and describe the relationship between the strategy formulation process and the strategy implementation process.
Study smarter with the SolutionInn App