ONLY NEED ASSISTANCE WITH #2 A client starts with $200.00 in a no-interest savings account and...

ONLY NEED ASSISTANCE WITH #2

A client starts with $200.00 in a no-interest savings account and deposits $40 into the account each month with no withdrawals. A function f has input x = months that have passed and output y = amount of money in the account.
1. Using Excel or another spreadsheet app, create a table to represent f where the first column contains inputs x = 0,1,2...20 and the second column represents the y value associated with the input x. Save a copy of the table (screenshot, snapshot, ...) in a format that can be later converted to PDF through Microsoft Lens, Adobe Acrobat or another application.
2. Give an example (with a short explanation) of what types of clients you might
  i. Discuss their account using a table
  ii. Discuss their account using a graph
  iii. Discuss their account using a formula

Expert Solution

ekkarill92 answered 2 years ago

If you deposit $12,123 dollars into a savings account, what interest would you need to be...

If you deposit $12,123 dollars into a savings account, what interest would you need to be earning to have $16,642 dollars in the same account 4 years later? Answer as a percent and to the nearest hundredth of a percent as in xx.xx % and enter without the percent sign.

if you deposit 10,697 dollars into a savings account, what interest would you need to be...

if you deposit 10,697 dollars into a savings account, what interest would you need to be earning to have 19,962 dollars in the same account 4 years later? answer as a percent to the nearest hundredth of a percent as in xx.xx %

John starts a savings account by depositing $1,000 today and thenincreases the deposit by $50...

John starts a savings account by depositing $1,000 today and then increases the deposit by $50 each year until Year 20. If the bank pays an interest of 12% per year compounded yearly, what is the account balance at the end of 25 years?

1) Please explain the following terms: savings account, basic savings account, interest bearing checking account, money...

1) Please explain the following terms: savings account, basic savings account, interest bearing checking account, money market deposit accounts, and certificate of deposits 2) What is the difference between a bond and a certificate deposit

If a savings account pays 6% p.a. interest rate, how much money do you need to...

If a savings account pays 6% p.a. interest rate, how much money do you need to deposit to accumulate $72,566 in 9 years? Note that the bank will compound interest monthly.

I only need assistance in answering Part 2 questions. Part 1 was included for background information....

I only need assistance in answering Part 2 questions. Part 1 was included for background information. Please and Thank You! Part I – Infertility Issues Jane sat nervously in the examination room. She had no idea what to expect. Her husband, Brian, gave her a reassuring smile and squeezed her hand. There was a knock on the door and then it opened to admit the physician. “Hello, Jane. I’m Dr. Klein and I’ll be doing your fertility assessment today.” “It’s...

Bank A offers a savings account with interest rate of 2% compounded quarterly. Bank B offers...

Bank A offers a savings account with interest rate of 2% compounded quarterly. Bank B offers a savings account with interest rate of 2.25% compounded semi-annually. Assume customer can deposit $5,000 and leave it on deposit for 4 years. What would be the final value for each bank account?

An amount of $10,000 is deposited into a savings account that pays interest at a rate...

An amount of $10,000 is deposited into a savings account that pays interest at a rate of 7%. If 10 equal annual withdrawals are made from the account starting one year after the money was deposited, how much can be withdrawn so that in the fifth year one would be able to withdraw an additional $1,000 and the account would be depleted after 10 years? Explain verbally in detail and sketch a timeline to illustrate.

Suppose, instead, Justin deposits 100 into a savings account, paying nominal interest rate i (2) =...

Suppose, instead, Justin deposits 100 into a savings account, paying nominal interest rate i (2) = 2%, at the beginning of each half year for 10 years. The interest earned from this account can be withdrawn at the end of each year and reinvested into another account earning AEIR 4%. Find the accumulated value of his holdings (in both accounts) at the end of 10 years.

Suppose you open today (year 0) a savings account with $5,000; the account earns an interest...

Suppose you open today (year 0) a savings account with $5,000; the account earns an interest of 3% APR annually. At the end of year 2 you deposit an additional $5,000 in the savings account, and then at the end of year 7 you deposit another $5,000 in the account. There is a total of 3 deposits made so far. If you did not make any withdrawals or additional deposits, then approximately what is the balance (FV) in the account...

Question