Question

without using a financial calculator or excel. Please provide all formula used and variables with clear steps

Question 8 The rate of interest earned in a banks savings account is 8% per annum effective (compound). Assume that there is

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

8. a) The account balance at the end of 8 years would be equal to the future value of all investments less the future value of all withdrawals

So,

Account balance = 100*(1+0.08)^8 + 200*(1+0.08)^7 = $ 527.86

b) In this case

Account balance = 100*(1+0.08)^8 + 200*(1+0.08)^7 - 300* (1+0.08)^2 = $ 177.94

  

Add a comment
Know the answer?
Add Answer to:
without using a financial calculator or excel. Please provide all formula used and variables with clear...
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
  • without using a financial calculator or excel. Please provide all formula used and variables with clear...

    without using a financial calculator or excel. Please provide all formula used and variables with clear steps (10) Please write your answer in the answer book provided. Show your workings. Circle your final answer. (a) A life insurer sells a 15-year term certain annuity which pays an annual effective rate of interest i = 4% to the policyholder. If the customer wants to purchase the annuity which pays $1,500 at the end of each year for 15 years, what is...

  • without using financial formulas just basic math formulas are eligible. Please provide all formula used and...

    without using financial formulas just basic math formulas are eligible. Please provide all formula used and variables with clear steps. Please use Goal Seek Tool in excel. EXCEL Question 1 (Home Loan) (3marks] Construct an EXCEL spreadsheet, which projects cash flows of a home loan with yearly loan repayments, ie. the loan is paid by payments at the end of each year for n years, until the loan is completely paid off. Please use your spreadsheet to answer the following...

  • I need to find the solutions using a BA 2 Plus financial calculator NOT through excel....

    I need to find the solutions using a BA 2 Plus financial calculator NOT through excel. 5 and 6 are not needed But 9 and 10 are very important. Question 5 5 pts You are taking out a car loan and will make payments of $315 each month (beginning one month from today). for a total of 60 monthly payments. If the interest rate on the loan is 0.83% (the effective monthly rate on this loan), how much are you...

  • Please answer a-bneeds to show workings no excel (10+5+15-30 narks) Question 2: Application of Time Value...

    Please answer a-bneeds to show workings no excel (10+5+15-30 narks) Question 2: Application of Time Value of Money (Mortgages) (30 marks) Suppose your parents wish to buy a house whose current market value is $1 50,000. They have approached a loan officer at the Bank of Nova Scotia who offers them 25-year mortgage financing for 75% of the purchase price at a rate of 6.75%, Payments are to be made on a monthly basis even though the bank is required...

  • Without the use of excel: A borrows 20000 for 8 years and repays the loan with...

    Without the use of excel: A borrows 20000 for 8 years and repays the loan with level annual payments at the end of each year. B also borrows 20000 for 8 years, but pays only interest as it is due each year and plans to repay the entire loan at the end of the 8 year period. Both loans carry an effective rate of 8.5%. How much more interest will B pay than A pays over the life of the...

  • EXCEL Question 1 (Home Loan) (3marks] Construct an EXCEL spreadsheet, which projects cash flows of a...

    EXCEL Question 1 (Home Loan) (3marks] Construct an EXCEL spreadsheet, which projects cash flows of a home loan with yearly loan repayments, ie. the loan is paid by payments at the end of each year for n years, until the loan is completely paid off. Please use your spreadsheet to answer the following questions: (a) Given loan amount is $600,000, annual effective interest rate i is 11%, loan term is 20 years. Find the annual repayment amount. (b) Given annual...

  • 1. What monthly payment is required to amortize a loan of $50,000 over 14 years if...

    1. What monthly payment is required to amortize a loan of $50,000 over 14 years if interest at the rate of 6%/year is charged on the unpaid balance and interest calculations are made at the end of each month? (Round your answer to the nearest cent.) $ 2. The Flemings secured a bank loan of $368,000 to help finance the purchase of a house. The bank charges interest at a rate of 3%/year on the unpaid balance, and interest computations...

  • Calculate all of the problems in the document below in an Excel spreadsheet or on a...

    Calculate all of the problems in the document below in an Excel spreadsheet or on a financial calculator. Please show your work in order to get credit. For each problem, state the inputs given, what you are being asked to find (the missing input), and then use the Finance function to get the correct answer (if using Excel). 1. If you wish to accumulate $100,000 in 5 years, how much must you deposit today in an account that pays an...

  • 1. Narelle borrows $600,000 on a 25-year property loan at 4 percent per annum compounding monthly....

    1. Narelle borrows $600,000 on a 25-year property loan at 4 percent per annum compounding monthly. The loan provides for interest-only payments for 5 years and then reverts to principal and interest repayments sufficient to repay the loan within the original 25-year period. Assume rates do not change. a) Calculate the monthly repayment for the first 5 years. (CLUE: it is INTEREST ONLY) (2 marks) b) Calculate the new monthly repayment after 5 years assuming the interest rate does not...

  • please show me how to solve using a financial calculator if possible....thanks in advance BE6.7 (LO...

    please show me how to solve using a financial calculator if possible....thanks in advance BE6.7 (LO 2) John Fillmore's lifelong dream is to own his own fishing boat to use in his retirement. John has recently come into an inheritance of $400,000. He estimates that the boat he wants will cost $300,000 when he retires in 5 years. How much of his inheritance must he invest at an annual rate of 8% (compounded annually) to buy the boat at retirement?...

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