Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
Real Estate Finance Assignment #3 Assignment Objectives: Help your Aunt Joyce decide whether or not to refinance her current loan given current interest rates and several different mortgage loan options. Assignment Instructions: She currently owes $131,600 on an original $136,193 15-year FRM loan that she originated 2 years ago at 4.375%. Unlike earlier assignments, you are responsible to use your own knowledge of Excel to build spreadsheets to answer each of the questions listed below. In order to help facilitate grading, please download the Excel file listed on Blackboard and place your answers to the listed questions in the space provided on the first worksheet of that file. Questions: 1. Your aunt has already received several loan quotes from different banks. Determine the monthly payment and effective borrowing cost for each loan below by creating a separate worksheet for each $131,600 loan given she prepays after 8 years (96 months): a. 30-year FRM loan at 3.624% with $2,367 in origination fees b. 30-year FRM loan at 3.75% with $1,617 in origination fees c. 15-year FRM loan at 2.88% with $1,859 in orig. fees and a 2% prepayment penalty applied towards any principal repaid beyond that is scheduled. d. 30-year 5/1 Hybrid ARM with an initial interest rate of 2.75% and $2,193 in origination fees. After the 60th payment, you assume the interest rate will immediately increase to 6.75% for the remaining payments. 2. Each lender has offered to ‘roll-in’ any origination fees to the loan’s principal, but requires the loan-to-value (LTV) to be less than or equal to 80% at origination. Calculate the required appraised value of the property assuming she does and does not “roll-in” the origination fees for each loan option. 3. What is the net present value (NPV) of the refinance decision if she chooses loan Option B, prepays after 8 years, does not roll-in fees, and has a monthly discount rate of 0.1%? 4. Your aunt currently earns $64,000 per year and pays $741 and $259 per year in property taxes and hazard insurance, respectively. Given that the lender requires that her monthly debt-to-income ratio must be less than 45%, what is maximum size of loan she can obtain if she chooses loan option A? 5. In addition to the NPV of the decision, explain in words 1 additional factor discussed in class she should take into consideration before deciding to refinance.
The Wei Corporation expects next year's net income to be $20 million. The firm's debt ratio is currently 45%. Wei has $10 million of profitable investment opportunities, and it wishes to maintain its existing debt ratio. According to the residual dis..
Present value of a perpetuity. What is the present value of a $400 perpetuity if the interest rate is 6%? Round your answer to the nearest cent.
Cyclone Software Co. is trying to establish its optimal capital structure. Its current capital structure consists of 40% debt and 60% equity; however, the CEO believes the firm should use more debt. The risk-free rate, rRF, is 6%; the market risk pre..
Quad Enterprises is considering a new three-year expansion project that requires an initial fixed asset investment of $2.64 million. The fixed asset falls into the three-year MACRS class. The project requires an initial investment in net working capi..
Fargo Memorial Hospital has annual patient service revenues of $14,400,000. It has two major third-party payers, and some of its patients are self-payers. What is Fargo's average collection period? What is the hospital's current receivables balance?
A corporation is evaluating the relevant cash flows for a capital budgeting decision and must estimate the terminal cash flow. The proposed machine will be disposed of at the end of its usable life of five years at an estimated sale price of $2,000. ..
if you have an investment that pays you $4000 two years from today,$5000 three years from today, and $6000 four years today. What is the value of the investment today if the appropriate interest rate 6% per year compounded annually?
Which one of the following is a speculative motive for holding cash? Southern Mills sells handmade cotton goods to national retail chains, to regional wholesale firms, and to small specialty shops. You would expect Southern Mills to: A windshield is ..
Aaron Knape Plans on buying a '64 Chevy Impala low rider for $60,000 in 8 years and thinks he can get 5% annually from his investments. How much should he invest per year to meet his goal and cruise around with the top down?
(Preferred dividend) a company has an outstanding issue of $100.00 par value per stock. it recently declared at $7.00 per par share dividend on its common stock. how much will the company pay in annual per-share preferred dividends if the preferred i..
A firm sells its $1,170,000 receivables to a factor for $1,134,900. The average collection period is 1 month. What is the effective annual rate on this arrangement?
Fleet skills test can be accomplished on a driving range or in actual traffic conditions. Give at least one advantage and one disadvantage of each testing environment.
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd