How much interest will you earn over the life of the loan

Assignment Help Financial Management
Reference no: EM131300088

You are lending your friend $25,000. She agrees to repay the loan in equal quarterly payments over a three-year period at an interest rate of 8% compounded quarterly. Using excel functions, answer the following:

a. Set up an amortization schedule for a $25,000 loan to be repaid in equal installments at the end of each quarter for the next 3 years.

b. How much interest will you earn over the life of the loan?

Reference no: EM131300088

Questions Cloud

Annual deposits into a retirement account : You make $9,900 annual deposits into a retirement account that pays an APR of 9.7 percent compounded monthly. How large will your account balance be in 32 years?
How much interest in total does he pay on credit card debt : Simon recently received a credit card with an 18% nominal interest rate. With the card, he purchased an iPad for $350. The minimum payment on the card is only $10 per month. How much interest in total does he pay on his credit card debt?
The presence of taxes and bankruptcy costs : RFC Corp. has announced $1 dividend. If RFC's price last price cum-dividend is $50, what should its first ex-dividend price be (assuming perfect capital markets)? Why? Does your answer change in imperfect markets i.e. in the presence of taxes and ban..
What nominal rate will you charge your customers : As a jewelry store manager, you want to offer credit sales to your customers, with interest on outstanding balances paid monthly. However, to finance your working capital, you must borrow funds from your bank at a nominal 6%, monthly compounding. For..
How much interest will you earn over the life of the loan : You are lending your friend $25,000. She agrees to repay the loan in equal quarterly payments over a three-year period at an interest rate of 8% compounded quarterly. Using excel functions, answer the following: Set up an amortization schedule for a ..
What are some uses and limitations of financial ratios : How do you think financial ratios differ across different industries? Compare two industries of your choice and select a few ratios and explain whether you think the ratios would be higher or lower for each of those industries and explain why. What a..
Find zero coupon bond with a par value : You find a zero coupon bond with a par value of $10,000 and 22 years to maturity. The yield to maturity on this bond is 4.4 percent. Assume semiannual compounding periods. What is the price of the bond?
Difference between interest rate risk and reinvestment risk : Explain the difference between interest rate risk and reinvestment risk. rank the following types of securities in order of both interest rate risk and reinvestment risk, with 1 being the lowest and 3 being the highest.
Calculate the present value of growth opportunities : Parcel Corporation Company plans $10 dividend next year (100% of earnings). Instead, company plows back 30% of earnings (i. e plowback ratio Is 30% and payout ratio is 1-30% = 70% and dividend payment is $7 = 70%* 10) at firm's current return on equi..

Reviews

Write a Review

Financial Management Questions & Answers

  Invest in certificates of deposit

Raya Mutual Fund of Kuala Lumpur has RM5 million to invest in certificates of deposit (CDs) for the next six months (180 days). It can buy either a CIMB Bank CD with an annual yield of 10% or a Mumbai (India) Bank CD with a yield of 12.5%. Determine ..

  What is the accounts receivable period

Suppose that the inventory period is 40 days, the accounts payable period is 15 days, and the cash cycle is 35 days. What is the accounts receivable period? (Note: Operating Cycle = Inventory Period + Accounts Receivable Period)

  Why are capital gains excluded from this model

A stock’s intrinsic value can be estimated by discounting expected dividends (or cash flows) to the present using the investor’s require rate of return. Why are capital gains excluded from this model? Does the exclusion of capital gains limit its val..

  Present value of investment that has three cash flows

What is the present value of an investment that has three cash flows of -$3000, $4,000, and $6,000? These cash flows occur at the end of year 1, 2, and 3 respectively. Use a discount rate (required rate of return) of 13.5%.

  Fixed costs-variable costs

A company has $7.30 per unit variable costs and $5 per unit fixed costs at a volume of 50,000 units. If the company marks up total costs by 0.51, what price should be charged if 70,000 units are expected to be sold?

  About the growth rates

Shalit Corporation's 2011 sales were $5 million. Its 2006 sales were $2.5 million. At what rate have sales been growing? Suppose someone made this statement: "Sales doubled in 5 years.

  The child withdrawals an equal sum twice per year

Parents deposit $7,000 into a savings account at the end of each year for 22 years to help their child pay for college. The savings account pays 7% interest per year, compounded monthly. The child withdrawals an equal sum twice per year while in coll..

  What is the project payback period if the initial cost

An investment project provides cash inflows of 200, 400, 670, 890, 1130, 1040, 880, 740, 530, 200, 110, 30 each year starting in year 1. What is the project payback period if the initial cost is $5,600? this must done in excel.

  Todds Dilemma-Common Stocks-Mutual Funds or ETFs

Todd O’Hanlon has worked in the management services division of Focus Consultants for the past five years. He currently earns an annual salary of about $120,000. At 33, he’s still a bachelor and has accumulated about $100,000 in savings over the past..

  What is the rate of return on this investment

Rob purchased a rare car for $246,800 ten years ago. Today, that car has a market value of $815,000. What is the rate of appreciation on this car? Charlie invested $7,200 in a stock last year. Currently, this investment is worth $8,788.38. What is th..

  How long will you wait from now

You expect to receive $15,500 at graduation in three years. You plan on investing it at 12 percent until you have $86,000. How long will you wait from now? (Do not round intermediate calculations and round your final answer to 2 decimal places. (e.g...

  Breakeven and sensitivity analysis

The goal of this exercise is to explore the trade-offs associated with the NPV of a solar collector project. The QFM for this project is: Development costs are $100K/qtr for Y1. Ramp-Up costs are 10K for Y1 Q4, 50K for Y2 Q1, and 5K for Y2 Q2. How wo..

Free Assignment Quote

Assured A++ Grade

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!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd