Reference no: EM131868678
1. Use excel to complete a 5 year spreadsheet for buying versus renting. Data: home cost $500,000, loan info 80% L/V, 30 years, 4% monthly, appreciation rate in price AND rent 5%, tax rate 40%, 1st year rent $2,500/month, property taxes plus insurance and maintenance 2%, sale transaction costs 3%, holding period 5 years. Make your columns for time zero and each of the 5 years, and your bottom line the ATCFlows for each year. For year 5 it will be the sum of the after tax operating cash flow and the ATCFsale. Calculate the IRRat for buying.
2. Graduated payment problem. a. Use excel to calculate the initial payment of the following FHA GPM loan: $300,000, 30 years, 3%, monthly, 4 increases or steps (years 2, 3, 4, and 5-30) of 10% each. When I solve this problem I actually write the TVM formulas using parentheses and the exponential key ^. Use whatever method you like but remember it must work on excel with NO calculator assistance. It must solve for both loans. b. now change the loan to $430,000, 6%, 30 years, monthly, same step increases. Solve for new payment.
3. ARM problem. Local lender Nice and SLO Mortgage offers a 30 year, $250,000 ARM under the following terms: Teaser rate (for one year) 2% Index 1 year COFI Annual reset Margin 2.5% Interest rate cap 2% annually, 5% lifetime..note that the adjusted rate can never be above 7% No payment caps No negative amortization 2 points charged Build a 5 year spreadsheet for this loan. The following forward COFI rates apply: BOY2 4%, BOY3 5%, BOY4 5.5%, BOY5 4.5%. You need one or more if statements to get excel to choose between the capped and uncapped lifetime interest rates. Solve for the yield (APR) to the lender.
Identify a project that you can work on
: identify a project that you can work on, i.e. a defined piece of work that you can plan, investigate, develop and deliver during your time at your internship
|
Define specific marketing issues to which article relates
: The purpose of this assignment is to keep students up-to-date with current events, encourage critical thinking and develop writing skills for communication.
|
What is value of your forward contract
: Suppose you sell four-month forward contract at $42. What is the value of your forward contract?
|
How much does she need to borrow to purchase the? yacht
: On December? 31, Beth Klemkosky bought a yacht for ?$80,000 and paid ?$16 ,000 ?down, how much does she need to borrow to purchase the? yacht?
|
Spreadsheet for buying versus renting
: Use excel to complete a 5 year spreadsheet for buying versus renting. Calculate the IRRat for buying.
|
Compound interest on the unpaid balance
: Mr. Bill S.? Preston, Esq., purchased a new house for ?$100,000 and paid ?$10,000 upfront. How much does he need to borrow to purchase the? house?
|
Identify the steps in the contingency planning process
: Identify the 7 steps in the contingency planning process, and explain how each step will be addressed for the surgical center.
|
What is the break even point of your investment
: What is the payoff of your position if the stock is at $57.50 at maturity? What is the Break Even Point (BEP) of your investment?
|
Dividend payment requirements of a common stock
: Discuss the dividend payment requirements of a common stock versus preferred stock, in terms of which type of stock has a primary
|