Bank account to make the decision alternatives equivalent

Assignment Help Financial Management

Reference no: EM131985249

You would like to take out a $300,000 loan for a 30-year fixed mortgage and the bank is offering a 30-year fixed rate annual rate of 5.0% with monthly payments. (Note: the interest rate given here is an annual value and you must correct for monthly payments.) Use the APR convention for rate conversion. Call the worksheet “Simple Loan”. a. The bank is willing to offer a lower interest rate (annual rate of 4.85%) if you put $30,000 as a down payment, reducing the amount of the loan. If the alternative to putting $30,000 down is to leave the money in a bank savings account that yields 1% annually, what financial decision makes more sense? Defend your answer and be sure to explain any assumptions made. b. Now use Goal Seek to determine the interest rate required for the bank account to make the decision alternatives equivalent.

Pls show the excel screenshot and excel functions applied.

Reference no: EM131985249

Questions Cloud

What is the effective annual cost of trade credit : Pets store inc. sells on terms of 3/15, net 75. What is the effective annual cost of trade credit under these terms? Use a 365- day year.

How much of their first payment goes toward interest : Construct the first row of the amortization table for their student loans. How much of their first payment goes toward interest?

How much cash will larry and laurie need at? closing : Closing Costs. Larry and Laurie have found a home and made a $101.200 offer that has been accepted. How much cash will Larry and Laurie need at? closing?

What is bart present value of the lease payments : What is Bart's present value of the lease payments? Barts implied interest rate in the lease payment is?

Bank account to make the decision alternatives equivalent : Now use Goal Seek to determine the interest rate required for the bank account to make the decision alternatives equivalent.

Difference between governmental funds and enterprise funds : Describe in your own words the difference between governmental funds and enterprise funds.

What is the percentage change in price of bond : If interest rates suddenly rise by 2 percent, what is the percentage change in the price of Bond Sam and Bond Dave?

Very mature in their product life cycles : Declining Products Corporation produces goods that are very mature in their product life cycles.

The dividends for the foreseeable future : Investors expect a growth rate of 6.00% on the dividends for the foreseeable future. What is the current fair price for the stock?

User Account

All Pages