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.
Advantage First Corporation has sales of $4,964,060; income tax of $514,886; the selling, general and administrative expenses of $224,035; depreciation of $368,851; cost of goods sold of $2,900,500; and interest expense of $101,207. What is the amoun..
You buy a share of The Ludwig Corporation stock for $21.20. You expect it to pay dividends of $1.00, $1.15, and $1.3225 in Years 1, 2, and 3, respectively, and you expect to sell it at a price of $28.83 at the end of 3 years. Calculate the growth rat..
Create a BUSINESS PLAN OUTLINE for a Brewing company in California. The Economics of the Business. Revenue Drivers and Profit Margins. Fixed and Variable Costs. Operating Leverage, and Its Implications
Lucky Inc. has a target capital structure of 53% common equity and 47% debt to fund its 5 billion in operating assets. Its WACC is 12%. Its before tax cost of debt is 9.89%. Its tax rate is 35%. What is the expected growth rate of the company? If the..
A $150,000, 15-year, monthly payment mortgage loan carries an interest rate of 5.5%, plus three points. The points are financed. What is the lender’s expected annual yield if the loan is amortized over the full 15 years?
An oil company has paid $100,000 for the right to pump oil on a plot of land during the next three years. A well has already been sunk and all other necessary facilities are in place. The land has known reserves of 60,000 barrels. The company wish..
What is the (1) marginal and (2) average tax rate paid for a firm with taxable income of a). $25,000? b). $85,000? c). $250,000? d). $12 million? e). $200 million?
Union Local School District has bonds outstanding with a coupon rate of 3.7 percent paid semiannually and 26 years to maturity. The yield to maturity on these bonds is 4.3 percent and the bonds have a par value of $10,000. What is the price of the bo..
You calculate an average return of 10% and a standard deviation of 5%. Assuming the returns are normally distributed, what is the probability that the investment will yield a return of less than 5%?
The number one semiconductor company in the world, Applied Materials, recently merged with the world's number three semiconductor company, Tokyo Electron. The stock prices of both companies went up significantly after the merger was announced, which ..
The following items are components of a traditional balance sheet. How much are the total assets of the firm
Tall Trees, Inc. is using the net present value (NPV) when evaluating projects. You have to find the NPV for the company’s project, assuming the company’s cost of capital is 10.66 percent. The initial outlay for the project is $414,171.
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