Question

In: Finance

A large bank sent you what looks like junk mail, but upon closer examination you realized...

A large bank sent you what looks like junk mail, but upon closer examination you realized it might be worth a second look. The mailer outlined a loan and investment program, designed to help first time home-buyers accumulate funds for a down payment on a primary residence. The basic outlines of the loan program are as follows.

  • Up to $25,000 loan
  • 3% annual interest rate
  • Ten year final maturity will full amortization

In order to qualify you would need a job and be willing to invest the loan proceeds into a fund managed by the bank. The investment fund is expected to return approximately 6% per annum. You will be required to pledge the investment account balance as collateral for the loan and if you fail to make monthly loan payments you forfeit the investment account balance. You will be charged no annual fees on your investment account so long as you are current on your loan payments.

Please answer the following questions.

  1. Assuming a $25,000 initial loan balance, what excel formula(s) would you use to calculate the minimum monthly loan payment? Write out the formula and the relevant formula inputs.

Rate =

Nper =

Pmt =

{pv] =

[fv] =

[type] =

Monthly loan payment ______________________

  1. What is your expected investment account balance at the end of 10 years? Write out the excel formula you would utilize and the relevant inputs.

Rate =

Nper =

Pmt =

[pv] =

[fv]=

[type] =

Accumulated investment account balance ________________

  1. Assuming you utilized the investment account balance to fund a down payment, equal to 20% of the value of a house, how much could you afford to pay for the house and what would the initial mortgage balance on the house be?

Property Value _________________

Down Payment ________________

Mortgage _____________________

  1. Assuming the mortgage balance in Part C, what is the estimated monthly mortgage payment assuming 4.5% fixed rate, 30 year full amortizing loan? Write out the excel formula you would use to calculate the monthly payment and write down the relevant inputs.

Rate =

Nper =

Pmt =

[pv] =

[fv] =

[type] =

Monthly mortgage payment=

Solutions

Expert Solution


Related Solutions

What it Looks Like to the User The program will loop, asking the user for a...
What it Looks Like to the User The program will loop, asking the user for a bet amount from 0 to 100 (assume dollars, you can use ints or longs). If the user types a 0 that means she wants to quit. Otherwise, accept the amount as their bet and simulate a slot machine pull. Your program will print out a line that looks like a slot machine result containing three strings. Some examples are:  BAR 7 BAR, 7 7 cherries,...
draw a picture of what you think recombinant plasmid looks like. in your drawing, show the...
draw a picture of what you think recombinant plasmid looks like. in your drawing, show the approximate location of any antibiotic resistant gene, the gene of interest, the restriction of endonuclease cutting sites
The United States has sent extremely large numbers of troops to countries like Iraq and Afghanistan...
The United States has sent extremely large numbers of troops to countries like Iraq and Afghanistan over the past decade. Record numbers of soldiers returning from combat duty in the Middle East have been diagnosed as suffering from posttraumatic stress disorder (PTSD). Considering our understanding of PTSD, why do you imagine these figures have grown so rapidly over the last few years? What might be possible treatment options for addressing this matter? Explain.
Please explain what infrared reflectance oculography is. What it is, what it looks like, what it...
Please explain what infrared reflectance oculography is. What it is, what it looks like, what it is use for. Please be as detailed as possible! Thank you!
Explain the presentation of what a hypokalemic patient looks like? What is your priority?
Explain the presentation of what a hypokalemic patient looks like? What is your priority?
It looks like a four-door SUV, drives like a four-door SUV but isn’t. What is it?...
It looks like a four-door SUV, drives like a four-door SUV but isn’t. What is it? This company uses 5% of the world’s sugar! They were the first large German Company to list on the New York Stock Exchange. You see them everywhere but no one knows what a TEU is. What does China have to do with the Ford Mustang? The largest auto exporter from USA is? (in terms of value)
Please explain what infrared reflectance oculography is. What itis, what it looks like, what it...
Please explain what infrared reflectance oculography is. What it is, what it looks like, what it is use for.  
You are a school nurse. A 7-year-old boy has what looks like impetigo on his right...
You are a school nurse. A 7-year-old boy has what looks like impetigo on his right forearm. You call the mother at work at 10:00 a.m. and ask her to come immediately and pick up her son and seek medical attention. 1. What did you see that made you suspect impetigo? 2. Why should the child not be sent home on the bus with a note for the mother? 3. How will the mother be expected to care for her...
NURSING EVALUATION (DEFINE AND DEFINE WHAT A "MET" GOAL LOOKS LIKE AND WHAT AN 'UNMET" GOAL...
NURSING EVALUATION (DEFINE AND DEFINE WHAT A "MET" GOAL LOOKS LIKE AND WHAT AN 'UNMET" GOAL LOOKS LIKE.
What would substitution reaction looks like compairing to an elimination reaction is GC analysis? And what...
What would substitution reaction looks like compairing to an elimination reaction is GC analysis? And what are the possible reasons that we might not see substitution in the GC analysis but only see Elimination reaction.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT