Johnny possesses $250,000 in cash savings and has a goal of purchasing a house. The current...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Johnny possesses $250,000 in cash savings and has a goal of purchasing a house. The current market price for a house that meets his preferences is $3,800,000. He expects property prices in his area to remain constant for the next 30 years. Johnny's monthly income amounts to $98,000, while his monthly expenses total $15,000. He has two options for acquiring his desired house: The first option is to borrow money from ABC Bank and purchase the house immediately. The second option is to save on his own with a goal to buy the house in 30 years. Johnny has access to a range of financial services offered by ABC Bank. The bank provides an attractive 6% annual deposit rate, compounded monthly, allowing Johnny to earn a monthly interest rate of 6%/12 when he deposits his money into a bank account. Alongside this, the bank offers him a 30-year fixed-rate mortgage contract featuring a borrowing rate of 12% per year, also compounded monthly. Notably, Johnny can secure a monthly loan amount of up to 38% of his monthly income from the bank. Under the assumption of consistent interest rates over the 30-year period, both the annual deposit saving rate and the annual mortgage rate will remain unchanged. Furthermore, both savings and loan payments will be made at the end of each month. Assuming that Johnny intends to save on his own and purchase the house 30 years later, let's proceed to answer the following questions: 1. If Johnny deposits his money in ABC Bank, what will be the future value of his cash savings after 30 years? (2.5 Marks) 2. Taking into consideration the future value of Johnny's cash savings, if he plans to purchase a house priced at $3,800,000 after 30 years, how much will he fall short by at that time? (2.5 Marks) 3. To accumulate enough money to cover the shortfall in 30 years and purchase the house, how much does Johnny need to save each month starting from next month onwards? (5 Marks) Assuming that Johnny wants to borrow money from the bank to purchase the house now, let's answer the following questions: 4. What is the maximum loan amount that Johnny can obtain from the bank today? (5 Marks) 5. Please complete the amortization table, Table 1, for the first two months considering that Johnny has borrowed the maximum amount. Copy the table onto your answer sheet. (5 Marks) Table 1: Amortization Table Month Beg. Balance Monthly Interest Paid Principal End. Balance Payment Paid 1 ? ? ? ? ? 2 ? ? ? ? ? 360 Total Total Total Loan Payment Total Interest Paid Principal Paid 6. What should be the total loan payment in Table 1? Why is there a difference between the initial loan amount offered by the bank and Johnny's total loan payment? How much is the difference? (5 Marks) 7. Considering Johnny's maximum loan amount from the bank and his savings, how much can he offer for the house at present, assuming no other costs are incurred? (3 Marks) Johnny possesses $250,000 in cash savings and has a goal of purchasing a house. The current market price for a house that meets his preferences is $3,800,000. He expects property prices in his area to remain constant for the next 30 years. Johnny's monthly income amounts to $98,000, while his monthly expenses total $15,000. He has two options for acquiring his desired house: The first option is to borrow money from ABC Bank and purchase the house immediately. The second option is to save on his own with a goal to buy the house in 30 years. Johnny has access to a range of financial services offered by ABC Bank. The bank provides an attractive 6% annual deposit rate, compounded monthly, allowing Johnny to earn a monthly interest rate of 6%/12 when he deposits his money into a bank account. Alongside this, the bank offers him a 30-year fixed-rate mortgage contract featuring a borrowing rate of 12% per year, also compounded monthly. Notably, Johnny can secure a monthly loan amount of up to 38% of his monthly income from the bank. Under the assumption of consistent interest rates over the 30-year period, both the annual deposit saving rate and the annual mortgage rate will remain unchanged. Furthermore, both savings and loan payments will be made at the end of each month. Assuming that Johnny intends to save on his own and purchase the house 30 years later, let's proceed to answer the following questions: 1. If Johnny deposits his money in ABC Bank, what will be the future value of his cash savings after 30 years? (2.5 Marks) 2. Taking into consideration the future value of Johnny's cash savings, if he plans to purchase a house priced at $3,800,000 after 30 years, how much will he fall short by at that time? (2.5 Marks) 3. To accumulate enough money to cover the shortfall in 30 years and purchase the house, how much does Johnny need to save each month starting from next month onwards? (5 Marks) Assuming that Johnny wants to borrow money from the bank to purchase the house now, let's answer the following questions: 4. What is the maximum loan amount that Johnny can obtain from the bank today? (5 Marks) 5. Please complete the amortization table, Table 1, for the first two months considering that Johnny has borrowed the maximum amount. Copy the table onto your answer sheet. (5 Marks) Table 1: Amortization Table Month Beg. Balance Monthly Interest Paid Principal End. Balance Payment Paid 1 ? ? ? ? ? 2 ? ? ? ? ? 360 Total Total Total Loan Payment Total Interest Paid Principal Paid 6. What should be the total loan payment in Table 1? Why is there a difference between the initial loan amount offered by the bank and Johnny's total loan payment? How much is the difference? (5 Marks) 7. Considering Johnny's maximum loan amount from the bank and his savings, how much can he offer for the house at present, assuming no other costs are incurred? (3 Marks)
Expert Answer:
Related Book For
Contemporary Financial Management
ISBN: 9780324289114
10th Edition
Authors: James R Mcguigan, R Charles Moyer, William J Kretlow
Posted Date:
Students also viewed these finance questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
Specific identification: (a) must be used under IFRS if the inventory items are not interchangeable. (b) cannot be used under IFRS. (c) cannot be used under GAAP. (d) must be used under IFRS if it...
-
Williams & Sons last year reported sales of $12 million, cost of goods sold (COGS) of $10 million, and an inventory turnover ratio of 2. The company is now adopting a new inventory system. If the new...
-
For the sequence given in Problem 97, show that Data from Problem 97 u 1 = 1, u n +1 = u n + (n + 1). (n + 1)(n + 2) Un+1 2
-
Develop the appropriate primary research question to be associated with this design. Develop a hypothetical research scenario that would necessitate the use of the Action Research Approach and a...
-
On December 21, 2008, Bucky Katt Company provided you with the following information regarding its trading securities. During 2009, Colorado Company stock was sold for $9,400. The fair value of the...
-
One of the biggest impacts of ___________ is the requirement for companies and their auditors to provide reports about the effectiveness of internal controls over the financial reporting process....
-
Forecasting with the Parsimonious Method and Estimating Share Value Using the ROPI Model Following are income statements and balance sheets for Cisco Systems. Cisco Systems Consolidated Statements of...
-
Q1: The following data were collected while running a closed traverse ABCDA. Calculate the missing data. Length Azimuth (m) Point Easting Northing Line Angle A 50 50 35.52 75 10' B= 100 ? BC ? D=...
-
The manufacturing costs of Kellam Industries for the first three months of the year follow: \ table [ [ , Total Costs,Units Produced ] , [ January , $ 2 , 4 0 0 , 0 0 0 , 1 0 , 0 0 0 units ] , [...
-
Do you think it is better to have higher variable costs andlower fixed costs, or higher fixed costs and lower variable costs?Why did you choose the structure you did? 2 answers
-
Consider the following x 8 6 assembly code. . data wordArray WORD 4 DUP ( ? ) , 1 , 2 , 3 , 4 dwordArray DWORD 1 , 2 , 3 , 4 , 5 , 6 , 7 , 8 code mov eax, SIZEOF wordArray mov ebx, LENGTHOF...
-
MicroK 8 s is a powerful, lightweight, reliable production - ready Kubernetes distribution that has a small disk and memory footprint. True False
-
Question 2 4 . We apply Dijkstra's algorithm to find the shortest path between two nodes in an undirected, weighted graph with all positive edge weights. We found the shortest distance between nodes...
-
The Two Dollar Store has a cost of equity of 12.7 percent, the YTM on the company's bonds is 5.4 percent, and the tax rate is 40 percent. If the company's debtequity ratio is .62, what is the...
-
From a medical tourist perspective, compare Shouldice with the traditional hospital in terms of the key factors of competition. Using Table 15-3, why would Shouldice attract patients from outside the...
-
Basically, what determines whether a bankrupt company is reorganized or liquidated?
-
How is risk defined in a financial sense?
-
Creole Industries, Inc., estimates that if it spent an additional $20,000 to hire another collection agent in its credit department, it could lower its bad-debt loss ratio to 3.5 percent from a...
-
Cress Trust owns houses in Marion County, for whom Rainbow Realty Group, Inc., sells, rents, and manages. The same person serves as Rainbows president and Cresss corporate trustee. Cress offers four...
-
Genevieve and William Timmons began their tenancy of a ground-floor apartment at Cobblestone Square in September 2011. Kingsley-Johnston, Inc., is a property management company responsible for...
-
Linda Miller rented 35 acres of pastureland in Wabaunsee County, Kansas, from William Burnett for $1,000 per year. Miller and her husband used the land to grow and harvest brome grass for their...
Federal Water Activities Selected Authorities And Programs Uk Edition - ISBN: 1624176496 - Free Book
Study smarter with the SolutionInn App