USE EXCEL TO SOLVE THIS PROBLEM AND SHOW THE FORMULA! Jake Mai deposited ¥300,000 in a bank account earning 9 percent per annum. How much interest will he earn in the fourth year? How much of the total will be simple interest and how much will be the result of compound interest?

USE EXCEL TO SOLVE THIS PROBLEM AND SHOW THE FORMULA! Jake Mai deposited ¥300,000 in a bank account earning 9 percent per annum. How much interest will he earn in the fourth year? How much of the total will be simple interest and how much will be the result of compound interest?

Pfin (with Mindtap, 1 Term Printed Access Card) (mindtap Course List)

7th Edition

ISBN:9780357033609

Author:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk

Publisher:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk

Chapter4: Managing Your Cash And Savings

Section: Chapter Questions

Problem 7FPE: Calculating interest earned and future value of savings account. If you put 6,000 in a savings...

See similar textbooks

Related questions

Q: n Hildebrand is trying to decide whether to invest money in a bank or in something a little riskier…

A: Interest earned by Don = A * [ (1 + i)t - 1] Where, A = Amount invested = $7,150 i = interest rate =…

Q: a businessman needs to have 100,000 due in 5 years. how much must he put into his 10% saving account…

A: Here in this question, we are required to calculate how much business man should put into investment…

Q: Imagine you have $200 today and you think to save your money in a bank for 2 years. The Bank A says…

A: Interest rate is the rate which an investor may earn on the deposits in the banks or the investment…

Q: You have just remembered that four years ago you placed $1,000 in a bank account. If the bank was…

A: PV x (1+r)n=FV

Q: You are currently investing your money in a bank account which has a nominal annual rate of 7…

A: The future worth means the amount that is to be received after a certain specified period of…

Q: If Martha puts P1,000 in the bank today at 6%, how much will she have in three years?

A: Future value = Present value(1 + Rate)^Time where, Present value = P1,000 Rate = 6% Time = 3 years

Q: Jacob has 5000 dollars and wants to earn 6500 dollars from the bank. If the bank gives a simple…

A: There are two types of interest offered by banks on deposits. One is simple and the other one is…

Q: how long it will take for $1,000 to amount to $1,900 at a simple interest rate of 12 1/2 percent.…

A: In this we have to calculate future value using simple interest rates.

Q: Based on Baumol (1952). Money in your savingsaccount earns interest at a 3% annual rate. Each…

A: Since we only answer up to 3 sub-parts, we’ll answer the first 3. Please resubmit the question and…

Q: Solve the following and show your solution. 1. Peter borrowed P100,000 at 8% compounded annually?…

A: Comment; We’ll answer the first question since the exact one wasn’t specified. Please submit a new…

Q: Consider two savings plans: Kelly deposits $415 per month in an account with an APR of 4.2% for 15…

A: Here we can use the concept of time value of money. The concept of time value of money states that…

Q: Suppose you invested $50,000 into an account at a private bank that attracts annual interest of 20%…

A: The present value of a sum shows the amount of money available today. It is the discounted value of…

Q: 1.) Leslie Mosallam, who recently sold her Porsche, placed RM10,000 in a savings account paying…

A: The concept of the time value of money states that the current worth of money is more than its value…

Q: Future value: Ted Rogers is investing $7,500 in a bank CD that pays a 6 percent annual interest. How…

A: Future value formula Used for Calculation: FV= PV(1+r)^n PV = present value = 7500 r= rate of…

Q: how many years your money will be doubled?

A: answer :- c) n= 6.12 years given present value PV= 10000 rate r=12% future value FV = 2*10000 =…

Q: You want to deposit sufficient money today into a savings account so that you will have $1,000 in…

A: Calculate the present value of amount as follows: Present value 3.5%= Future value / (1+rate)^years…

Q: How much must Queenie deposit in the bank that pays 10% compounded monthly, so she will have…

A: Present Value can be calculated using PV function in excel PV (rate, nper, pmt, [Fv], [type])…

Q: How much final amount would Emmanuel receives if he invests P250,000 for 1 year and 6 months at 12%…

A: A = P x n x r where, P= Principal Amount n= number of periods r= rate of interest Notes: Since you…

Q: How much money should a man invest in a bank account paying 8 percent annual interest compounded…

A: Interest Rate = 8% Continuous Compounding Future Value Required = 20,000 T (Time Period) = 4 years…

Q: A young man saved his money every quarter for 5 years into his bank account. He deposits P2,000 per…

A: i=(1+(r/m))^(m/q)-1 m= original compounding per period=12/2=6 q=new compounding per period=12/3=4

Q: John Jamison wants to accumulate $60,000 for a down payment on a small business. He will invest…

Q: You want to be able to withdraw $45,000 each year for 25 years. Your account earns 6% interest. a)…

A: Given: Withdraw amount =$45000Interest rate annually =6%Time=25 years

Q: you want to be able to withdraw $30000 each year for 20 years. Your account earns 9% interest. a)…

A: In the provided scenario, PMT = $30,000 Period is of 20 years, and Rate is 9%.

Q: Swee King makes a single deposit now in an account that pays 4% interest per year, and after 5…

A: The question is related to Interest effect of amounted deposits if interest rates increases.

Q: A recent government study reported that a college degree is worth an extra Php23000 per year in…

A: Compounding is the process in which an asset's earnings, from interest, are reinvested to generate…

Q: Lenter wishes to have php. 36,000 after 1 year and 3 months to be used for their educational tour.…

A: The present value is the value of the sum received at time 0. It is the current value of the sum…

Q: 2. Suppose Jun invested in a bank that gives a 5% interest rate per annum of 5%, an amount earned…

A: There are two types of interest that may be applicable on an investment; 1) Compound interest, and…

Q: Sandra Alcocer goes to her bank to ask for your help to get her out of her current predicament. She…

A: Here, Note: Here, two years to complete is considered as amount deposited after 2 years.

Q: If you want to have $22,327 in fifteen years, how much do you need to deposit in a bank account…

A: The deposit required today is calculated as the present value.

Q: A man invests his savings in two accounts, one paying 6 percent and the other paying 10 percent…

A: The question is based on the concept of Financial Management.

Q: (a) A bank account pays 5.5% annual interest, compounded monthly. How long will it take the money to…

A: a) Let the initial amount = P Final amount = Double of the initial amount = 2P r = 5.5% per annum =…

Q: Mrs. Reyes has Php 25,000.00 in an account providing 3% simple interest per year. She wishes to have…

A: Initial amount (P) = Php 25000 r = 3% Interest needed after 3 years = Php 5000 n = 3 years Let X =…

Q: K Suppose you receive $500 at the end of each year for the next three years. a. If the interest rate…

A: Present value is the value right now of some amount of money in the future. Formula : PV = FV x…

Q: How much would you need to deposit in an account now in order to have Php2000 in the account in 15…

A: The sum of future investment returns discounted at a particular level of rate of return anticipation…

Q: You are currently investing your money in a bank account which has a nominal annual rate of 7…

A: To estimate how long it will take to double an investment at a given interest rate, we can use the…

Q: A person would want to have K143.33 in 4 years time by depositing a single cash of K100 in a bank…

A: Compound interest is one of the ways that money invested earns interest. In compound interest, the…

Q: Donald Trump invests $3 million in a bank that promises to pay 4 percent annual interest rate…

A: The given problem can be solved using FV function in excel. FV function computes amount required in…

Q: How many USD should a person who constantly wants to receive 4500 USD at the end of each year invest…

A: The present value of a perpetual annuity is the current worth of an annuity which will continue till…

Q: Michael has a bank account that is worth $80,550. (a) Find the overall ROR if he had…

A: a) Calculation of the overall rate of return is calculated using the following formula: Compound…

Q: A recent government study reported that a college degree is worth an extra Php23000 per year in…

A: The future value measures the future worth of the current value of cash flows at a specified date…

Q: Mr. A wants to receive a consistent amount from a bank that offers 6%o interest to be compounded…

A: Annual receipt = Php 100,000 Number of annual payments = 10 First years of payment = 5th Year Annual…

Q: choose

A: To calculate which account to be chosen, we can calculate the effective annual rate. Effective…

Q: You deposited PHP1,500 in a bank with an interest rate of 5% for 1 year. What is the future value of…

A: The future value is the amount that will be received at the end of a certain period. In simple…

Q: You would like to have an accumulated amount of Php 60,000 in a savings account that pays you an…

A: Given that future value = Php 60000 interest rate = 4.25% /12= 0.35416666667% = 0.0035416667 n=…

Question

Video Video

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

Step 2

Step 3

Step 4

Step 5

Trending now

This is a popular solution!

Step by step

Solved in 5 steps with 4 images

SEE SOLUTION Check out a sample Q&A here

Similar questions

You put $250 in the bank for S years at 12%. A. If interest is added at the end of the year, how much will you have in the bank after one year? Calculate the amount you will have in the bank at the end of year two and continue to calculate all the way to the end of the fifth year. B. Use the future value of $1 table in Appendix B and verity that your answer is correct.
Use the tables in Appendix B to answer the following questions. A. If you would like to accumulate $4,200 over the next 6 years when the interest rate is 8%, how much do you need to deposit in the account? B. If you place $8,700 in a savings account, how much will you have at the end of 12 years with an interest rate of 8%? C. You invest $2,000 per year, at the end of the year, for 20 years at 10% interest. How much will you have at the end of 20 years? D. You win the lottery and can either receive $500,000 as a lump sum or $60,000 per year for 20 years. Assuming you can earn 3% interest, which do you recommend and why?
Use the tables in Appendix B to answer the following questions. A. If you would like to accumulate $2,500 over the next 4 years when the interest rate is 15%, how much do you need to deposit in the account? B. If you place $6,200 in a savings account, how much will you have at the end of 7 years with a 12% interest rate? C. You invest $8,000 per year for 10 years at 12% interest, how much will you have at the end of 10 years? D. You win the lottery and can either receive $750,000 as a lump sum or $50,000 per year for 20 years. Assuming you can earn 8% interest, which do you recommend and why?
Calculating interest earned and future value of savings account. If you put 6,000 in a savings account that pays interest at the rate of 3 percent, compounded annually, how much will you have in five years? (Hint: Use the future value formula.) How much interest will you earn during the five years? If you put 6,000 each year into a savings account that pays interest at the rate of 4 percent a year, how much would you have after five years?
You put $600 in the bank for 3 years at 15%. A. If Interest Is added at the end of the year, how much will you have in the bank after one year? Calculate the amount you will have in the bank at the end of year two and continue to calculate all the way to the end of the third year. B. Use the future value of $1 table In Appendix B and verify that your answer is correct.