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.

Presentation of the components of liabilities & shareholder : 1.Air France KLM (AF), a French company, prepares its financial statements according to International Financial Reporting Standards. |

New library building equipped with the latest technology : A university plans to have a new library building equipped with the latest technology, study rooms for the students, and more space for books and periodicals. The old building is too small and does not have any equipment. Can you justify the new buil.. |

Next generation technology grants access based on human : next generation technology grants access based on human attributes? |

What is the beta for the companys stock : You are told the WACC for the following firm is 7.95 percent. The company pays no dividends. What is the beta for the company’s stock? Debt: 100,000 bonds with a par value of $1,000 and a quoted price of 112.30. The bonds have coupon rate of 6.1 perc.. |

Real estate finance assignment : Real Estate Finance Assignment-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 p.. |

Write paper about aircraft maintenance hangar : Write paper about Aircraft maintenance Hangar |

Both warrants and convertibles are type of option securities : Both warrants and convertibles are types of option securities. Warrants bring in additional funds when exercised, while convertibles do not. Return on Assets will fall after a Convertible Bond is exchanged for equity. |

Research and discuss any current issues use of rfid : Research and discuss any current issues (use of RFID, freight damage issues, security, labor shortage) within Walmart. Make sure that you have proofread your paper and included the proper APA citations. |

Compute the current market value of this bond : A bond was issued 3 years ago at a coupon rate of 6%. Since then, interest rates have declined to 4%. The bond matures 20 years from today. Compute the current market value of this bond. |

## What is the principal balance on the loanYou take out a 30-year $450,000 mortgage loan with an APR of 7.75 percent and monthly payments. In 16 years you decide to sell your house and payoff the mortgage. What is your monthly payment? What is the principal balance on the loan? What is your t.. |

## What is the present value of this growing perpetuityYou are evaluating a growing perpetuity product from a large financial services firm. The product promises an initial payment of $24,000 at the end of this year and subsequent payments that will thereafter grow at a rate of 0.03 annually. If you use .. |

## What are the potential differences in cash flow for machineWhat are the potential differences in cash flow for a machine that is highly automated versus a machine that requires more employee supervision and ongoing input to run it? How will these different aspects of the new machine affect the final decision.. |

## How much could he withdraw at the beginning of eachYour uncle has $375,000 and wants to retire. He expects to live for another 25 years, and he also expects to earn 7.5% on his invested funds. How much could he withdraw at the beginning of each of the next 25 years and end up with zero in the account.. |

## Present and future values of a cash flow streamAn investment will pay $50 at the end of each of the next 3 years, $250 at the end of Year 4, $350 at the end of Year 5, and $600 at the end of Year 6. If other investments of equal risk earn 11% annually, what is its present value? Round your answer.. |

## What is the current price of the bondsCrossdyme Corporation issued 20-year, noncallable, 7.4% annual coupon bonds at their par value of $1,000 one year ago. Today, the market interest rate on these bonds is 5.5%. What is the current price of the bonds, given that they now have 19 years t.. |

## Difference between a correspondent and bankers bankWhat is the difference between a correspondent, respondent, and banker's bank? |

## What is the loans effective annual rateA credit card is offered with monthly payments and a 21.99% APR. What is the loan's effective annual rate (EAR)? |

## Making semi-annual paymentsLKM, Inc, wants to issue new 20 year bonds for some much needed expansion projects. The company currently has bonds on the market that sell for $972.78, making semi-annual payments, with a 6.5% coupon rate. What is the yield to maturity of the bond? |

## Rapid integration is usually importantRapid integration is usually important for all of the following reasons, except for: Minimizes employee turnover. Improves the morale and productivity of current employees of both the acquiring and acquired firms |

## What is the expected return for the projectWhat is the expected return for the project? If the required rate of return is 13%, should they proceed with the project? Why? Does this mean Project B is automatically eliminated from consideration? |

## Expected long-run growth rate for this stockA share of common stock has just paid a dividend of $3.00. If the expected long-run growth rate for this stock is 5 percent, and if investors require an 11 percent rate of return, what is the price of the stock? Show work |

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!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd