Question

Please Do NOT USE excel to solve .... Show me the steps and the equations to better understand the question

You have a habit of drinking a cup of coffee ($2.00 a cup) on the way to work every morning for 30 years. If you put the mone

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Given, APR = 5% p.a. compounded daily.

a). So, Equivalent interest rate per year = (1 + APR/n)^n - 1 = (1 + 0.05/365)^365 - 1 = 5.13% per year.

b). if rs 2 is deposited daily for next 30 years, Future sum can be calculate using formula

FV = PMT*((1+r/n)^(t*n) - 1 )/(r/n) = 2*(1+0.05/365)*((1+0.05/365)^(365*30) - 1)/(0.05/365) = $50832.90

Add a comment
Know the answer?
Add Answer to:
Please Do NOT USE excel to solve .... Show me the steps and the equations to...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Show the excel formulas used Ex. 1 You have $5,000 in your savings account that pays...

    Show the excel formulas used Ex. 1 You have $5,000 in your savings account that pays 4% interest. How much will you have in your account after 20 years, a) if your bank pays annually compounded interest? b) if your bank pays monthly compounded interest? c) if your bank pays daily compounded interest? Current balance Interest Years Compounding Annually Monthly Daily a) FV b) FV c) FV Ex. 2 If you need $10,000 in 7 years and you can earn...

  • Show the excel formulas used and answer all questions Ex. 1 You have $5,000 in your...

    Show the excel formulas used and answer all questions Ex. 1 You have $5,000 in your savings account that pays 4% interest. How much will you have in your account after 20 years, a) if your bank pays annually compounded interest? b) if your bank pays monthly compounded interest? c) if your bank pays daily compounded interest? Current balance Interest Years Compounding Annually Monthly Daily a) FV b) FV c) FV Ex. 2 If you need $10,000 in 7 years...

  • Solve the problem. Show your work and equations! Please do not show screenshots of Excel as...

    Solve the problem. Show your work and equations! Please do not show screenshots of Excel as your work shown. 4. The company yesterday paid their annual dividend of $2.00 and the expected price in 2 years is $100. The dividend payment is expected to grow at 7%. i) What is the stock's required return? ii) what is the price today? Use annual compounding

  • Please create a simple macro ( in Excel) to solve for the following problem: Suppose you...

    Please create a simple macro ( in Excel) to solve for the following problem: Suppose you spend $4.00 on coffee every day (e.g., that is $28 a week or $1,456 a year). Let $1,456 be your payment. Suppose you, a 22 year old college student, put that payment ($1,456) in an account every year at the end of each year for the next 40 years. Let's assume you can earn 8% on that account. What is the Future Value of...

  • Please solve using excel and show the steps and equations used in excel. thank you Example...

    Please solve using excel and show the steps and equations used in excel. thank you Example 3.4 The numbers given at the beginning of section 3.2 were as follows: 150/151 Zahra int Group A: Group B: Group C: 2, 3,4, 8 1, 2. 4, 10 0, 1,5, 11 Comp 1 (Woodla chem 144 as folder It Word psye ess soft Point mamas suf Chapter 3 Find the sample variance and the sample standard deviation of each group of numbers. Use...

  • Solve the problem. Show your work and equations! Please do not show screenshots of Excel as...

    Solve the problem. Show your work and equations! Please do not show screenshots of Excel as your work shown. 1. A bond with a coupon rate of 7.30% has a price that today equals $868.92. The $1.000 face value bond pays coupon every 6 months, 30 coupons remain, and a coupon was paid yesterday. Suppose you buy this bond at today's price and hold it so that you receive 20 coupons. You sell the bond upon receiving that last coupon....

  • Solve the problem. Show your work and equations! Please do not show screenshots of Excel as...

    Solve the problem. Show your work and equations! Please do not show screenshots of Excel as your work shown. 5. The company stock increases dividend by 5% each year and the expected dividend in 5 years is $5. Analysts expect that investors would require 10% return on this stock. The company will cease paying dividend after the 5th dividend (dividend in year 5). That is, the firm will pay 5 dividends annually and from year 6 shareholders will not receive...

  • Please don't use Excel Please use formula equations to solve this one not a picture Thanks!...

    Please don't use Excel Please use formula equations to solve this one not a picture Thanks! Consider the cash flow data in the Table below for two competing investment projects. At i 15 %, which of the two projects would be a better choice? Project A Project B EOY CF CF -$1,200 -$1,200.00 0 -$1,300 -$660.00 1 -$435 $820.00 2 $920.00 $975 $1280 $975 4 $1880 $1,475 5 $1,775 $1,600.00 6 $1775 $1880.00 7 $675 $780.00 8 $375 $380.00 9...

  • Solve the problem. Show your work and equations! Please do not show screenshots of Excel as...

    Solve the problem. Show your work and equations! Please do not show screenshots of Excel as your work shown. 3. The Company dividend appears to grow smoothly at a constant rate of 5.5%. Analysts forecast that next year's dividend should equal $3.8. Investors require 14% return on this class of stock. What would be the price in 7 years? Use annual compounding.

  • Bond and Stock Value and Evaluation. PLEASE SHOW ALL FORMULAS/EQUATIONS AND SHOW ALL OF YOUR WORK. Do not use Excel....

    Bond and Stock Value and Evaluation. PLEASE SHOW ALL FORMULAS/EQUATIONS AND SHOW ALL OF YOUR WORK. Do not use Excel. 4. The company yesterday paid their annual dividend of $2.00 and the expected price in 2 years is $100. The dividend payment is expected to grow at 7 %. i) What is the stock's required return? ii) what is the price today? Use annual compounding

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT