🏷️ LIMITED TIME OFFER: GET 20% OFF GRADE+ YEARLY SUBSCRIPTION →
Log in
Finance
1
answer
0
watching
289
views

  1. James Hunt’s Dream Apartment

Part 1

James Hunt currently earns a yearly salary of $100,000(paid on a monthly basis at the end of each month) and his averageincome tax rate is 25% (taxes are withheld by the employer from theemployee’s gross monthly pay). He wishes to buy an apartment inBoston. He can obtain from his bank a 30-year fixed rate mortgageloan at a nominal interest rate of 4.75% per annum, with equalmonthly payments paid at the end of each month.

James also has accumulated $150,000 in savings, which heholds in a separate bank account.

He figures that all other housing-related expenses(e.g., condominium fees, utilities, insurance, and property taxes)should come up to a total of about $500/month (assume that theseexpenses are all paid at the end of each month).

As he is trying to figure out how much he can afford topay for the apartment of his dreams, he suddenly remembers theadvice his mother once gave him:

  • Do not spend more than 1/3 of your monthly disposabletake-home pay on housing costs (mortgage and all otherhousing-related expenses); and,
  • Always keep a minimum of $50,000 available at all timesin your savings account, in case of an emergency.

Given all the information above, and if he follows hismother’s advice, what is the maximum price that James can afford topay for the apartment?

Part 2

Four years after having purchased the apartment, Jameslearns that mortgage interest rates have substantially declined dueto the recession and to the Federal Reserve Bank’s aggressiveexpansionary monetary policy. He currently still owes $283,333 onhis loan principal.

The 30-year mortgage interest rate is now at 4% and a15-year rate at 3.50%. In addition, his annual salary base is now$125,000, as a result of a recent promotion, and his savingsaccount was partially replenished and now stands at$80,000.

Rather than lowering his monthly mortgage payments,James is more interested in shortening the maturity of hismortgage, so as to save a substantial amount of future interestpayments. As a result, he wishes to switch from a 30-year to a 15year mortgage at 3.50%.

Assume that his average tax rate is now 30% , thathousing-related costs are now $600 instead of $500, and that theclosing costs (legal and processing fees to modify the mortgage)are approximately $5,000, payable at closing (when the new loan isapproved).

Assuming that James continues to strictly follow hisMom’s recommendations,

  1. How much of the existing loan principal would he haveto repay upfront before setting up the new loan? (Include theclosing costs to the amount).
  2. What is the total amount of interest that he would saveover the entire duration of the loan if he were to refinance it(i.e., switch to the 15-year mortgage loan mentionedabove)?
  3. Can he afford to refinance his loan, all thingsconsidered? Should he do it? Explain.

Watch
1
answer
0
watching
289
views

For unlimited access to Homework Help, a Homework+ subscription is required.

Jean Keeling
Jean KeelingLv2
28 Sep 2019

Unlock all answers

Get 1 free homework help answer.
Already have an account? Log in
Share

Related questions

Years are 2014 and 2015.

ABC is in its 4th year of operations. The company is experiencing cash flow issues and would like to utilize a budget to forecast cash flows. You are an outside consultant hired to assist in designing a model that ABC can utilize on an ongoing basis to forecast cash flow. The president of the company, Ms. Dream, has predicted an increase in sales of two percent per month from December 2014 through March 2015 Mr. Dream believes that after March, sales will remain steady through June 2015. The projected balance sheet for ABC as of December 31, 2015 is shown below: Cash $ 20,000 A/receivable 208,748 Marketable securities 25,000 Inventory 25,750 Buildings & equipment (net of accumulated depreciation) 225,000 Total assets $ 504,498 A/payable $ 101,384 Sales commissions payable 6,885 Bond interest payable 4,800 Property taxes payable 0 Bonds payable (4%- due in 2020) 360,000 Common stock 10,000 Retained earnings 21,429 Total liabilities and stockholders' equity $ 504,498 You will need the following information to prepare a master budget for the first quarter of 2015: 1) Projected sales for November 2015 are $225,000. Credit sales comprise 95% of total sales. Sales collected in the month of sale total 15%, in the month following the month of sale total 70%, and in the second month following the month of sale total 13%. Remaining sales are uncollectible. 2) Cost of goods sold total 55% of sales. Inventory purchases are made on account. Purchases paid for in the month of purchase total 20% and purchases paid for in the month following the month of purchase total 80%. Ending monthly Inventory is maintained at 20% of the following month’s projected cost of goods. 3) Projected monthly expenses include: Sales salaries $ 60,000 Advertising and promotion 4,000 Administrative salaries 25,000 Depreciation 3,000 Interest on bonds 1,200 Property taxes 1,500 Sales commissions of 3.0 percent of sales are paid in the month following the month of sale. 4) Additional manufacturing equipment would allow the company to increase production. The cost of the new equipment is $150,000. Ms. Dream plans on purchasing the equipment on January 1st and plans on paying for the equipment with cash and by liquidating the company’s marketable securities. Mr. Clark wishes to maintain a minimum cash balance of $15,000 at the end of each month. If necessary, he plans on obtaining a short-term note payable from a local bank. The minimum lending period for such a loan is three months. The current short-term interest rate is 7 percent per year and is expected to remain at this rate through the time the equipment is purchased. Mr. Clark would like to pay off the loan as quickly as possible. Payments must be made in $1,000 increments. 5) The board of directors would like to declare and pay dividends of $125,000 on the last day of each quarter. 6) The interest on any short-term borrowing will be paid when the loan is repaid. Interest on the bond payable is paid semiannually on February 28 and August 31 for the preceding six-month period. 7) Property taxes are paid quarterly on March 31, June 30, September 30, and December 31 for the preceding three-month period. Required: Assist ABC by building a model to forecast cash flow. Set up your model for the first quarter of 2015. The model should contain the master budget schedules shown below. Round all amounts to the nearest dollar. The model should allow ABC to change the assumptions provided above and quickly recalculate the forecasted cash balance at March 31, 2015. The assumptions may be included on a separate worksheet in your Excel file but all of the schedules below must be on one worksheet. Please Prepare Summary Cash budget in following table with all shown calculations and formulas.

Summary Cash Budget
January February March 1st Quarter
Cash receipts(Sch 2)
Less: Cash disbursement (Sch 4)
Change in cash balance during period due to operations
Sales of marketable securities(1/1/15)
Proceeds from bank loan
Purchase of equipment
Repayment of bank loan(03/31/15)
Interest on bank loan
Payment of dividends
Change in cash balance during the month
Beginning cash balance
Ending cash balance

Weekly leaderboard

Home
Homework Help 3,900,000
Finance 370,000
Start filling in the gaps now
Log in