1. My wife wants us to purchase a rental house at the beach in Delaware, where...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1. My wife wants us to purchase a rental house at the beach in Delaware, where we like to go periodically. We would need to borrow approximately $200,000.00 to make the deal. We can get a loan from a local Credit Union. It would be a $200,000 loan, but we must pay a $2500 not refundable processing fee, and we must purchase stock in the amount of $1000.00 which earns nothing (but we get it back at the end of the loan period) In addition, we would also incur a $1,000 not refundable appraisal fee (all of these would be withheld from the loan proceeds). The annual interest rate offered would be 4.6%, and we would make MONTHLY payments for 15 years until the loan is paid off. a. Calculate the Monthly payment on the $200,000 loan at 4.6% annual interest ROOT PRO 413 (1-(1+212) b. What would be the period 0 cash flow (loan proceeds- the stock purchase-the $5200000-1000, 2500 - 1000 = $115500 processing fee - the appraisal fee). If the house costs $235,000.00, how much would we have to come up with for the total out of pocket down payment? 4-68 If the house costs $235,000.00, how much would we have to come up with for the total out of pocket down payment? c. What would be the final period cash flow (the final payment + the stock back). 11 p d. Set the problem up in a spreadsheet and calculate the IRR of the cash flow stream. (be sure to convert it back to an annual rate and go to 4 places past the decimal) 1. My wife wants us to purchase a rental house at the beach in Delaware, where we like to go periodically. We would need to borrow approximately $200,000.00 to make the deal. We can get a loan from a local Credit Union. It would be a $200,000 loan, but we must pay a $2500 not refundable processing fee, and we must purchase stock in the amount of $1000.00 which earns nothing (but we get it back at the end of the loan period) In addition, we would also incur a $1,000 not refundable appraisal fee (all of these would be withheld from the loan proceeds). The annual interest rate offered would be 4.6%, and we would make MONTHLY payments for 15 years until the loan is paid off. a. Calculate the Monthly payment on the $200,000 loan at 4.6% annual interest ROOT PRO 413 (1-(1+212) b. What would be the period 0 cash flow (loan proceeds- the stock purchase-the $5200000-1000, 2500 - 1000 = $115500 processing fee - the appraisal fee). If the house costs $235,000.00, how much would we have to come up with for the total out of pocket down payment? 4-68 If the house costs $235,000.00, how much would we have to come up with for the total out of pocket down payment? c. What would be the final period cash flow (the final payment + the stock back). 11 p d. Set the problem up in a spreadsheet and calculate the IRR of the cash flow stream. (be sure to convert it back to an annual rate and go to 4 places past the decimal)
Expert Answer:
Answer rating: 100% (QA)
ANSWER a We may use the PMT function in Excel or Google Sheets to determine the monthly payment on t... View the full answer
Posted Date:
Students also viewed these general management questions
-
Jake has a vacation rental house at the beach. During the tax year, he and his immediate family used the house for 12 days for a personal vacation. Jake and his son spent two more weekends (4 days)...
-
Suzanne owns a vacation home at the beach in which she lived for 30 days and rented out for 61 days during the current year. Her gross rental income is $2,600. Her total expenses for the vacation...
-
What monthly payment for 15 years will pay off a $50,000 loan at 8.25% compounded monthly?
-
1. (Adverse Selection) Consider a labor market model with many identical firms hiring workers. The firms produce a homogeneous product with a constant-returns-to-scale technology and act as price...
-
Parent Company holds 90 percent of Sunway Company's voting common shares. On December 31, 20X8, Parent recorded a loss of $16,000 on the sale of equipment to Sunway. At the time of the sale, the...
-
Jesse Edwards, an employee of Carbon Processing and Reclamation, LLC (CPR), put unmarked boxes of company records in his car. Edwardss wife, Channon, who suspected him of hiding financial information...
-
Describe the exchange rate systems used by various governments,
-
Adams, Inc. customers mail in their orders to the Adams customer service center where clerks open the orders and review them for accuracy. The clerks then key orders into the computer at which time...
-
Find a model for the Body Mass Index (BMI) of a person, given that BMI varies directly as a person's weight in pounds and inversely as the square of the person's height in inches. If a 7 ft tall...
-
Suppose Ann is working on a project with John. Both must decide whether to put into a decent amount of effort into the project. Since Ann is the leader of the project, her contribution determines...
-
Edwards Company has projected sales and production in units for the second quarter of the year as follows: May April June 30,000 20,000 25,000 Sales Production.. 25,000 25,000 30,000 Required: a....
-
How does cultural relativism challenge traditional norms and what strategies can be employed to foster cross-cultural understanding in diverse societies ?
-
'White Label Industries', a medical equipment manufacturing organization has encountered some problem in its supply chain. The latest delivery it received from its lead supplier 'SecureIt' has...
-
Job - Order Costing Systems the importance of it in accounting and businnes, the practical application of how it is used, and examples of it being used and how imprtant it is?
-
The spatial part of the ground state energy eigenfunction for a one - dimensional simple harmonic oscillator is 0 ( x ) = ( m ) 1 4 e - m 2 h x 2 . Consider a quantum particle of mass m that moves in...
-
How can cultural appropriation be critically examined in contemporary artistic and commercial practices, and what frameworks exist to promote cultural respect and reciprocity ?
-
(9 pts) 3. Modern Garden operates a commercial nursery where it grows plants for garden centers throughout the region. Modern Garden has $6,000,000 in assets. Its yearly fixed costs are $1,800,000...
-
Place a tick in the appropriate grid to identify the balance that would be brought down in each of the following named accounts, in the books of Rizwy Mohamed: (a) In the Cash account: if Rizwy...
-
Discuss the relevance to financial analysts and investors of additional disclosures by MNEs with regard to corporate strategy and related issues.
-
What is your view of the major deficiencies/weaknesses in disclosure by MNEs today? In answering this, make clear your objectives and provide arguments to support your claims.
-
Is the standard of segmental reporting likely to improve following the recent changes to IAS 14?
Study smarter with the SolutionInn App