Tommy, a former student in Dr. Smith from Economy class, opened an account at First National...

Tommy, a former student in Dr. Smith from Economy class, opened an account at First National Bank on July 1, 2008 and made an initial deposit of $500. She then made 8 additional yearly deposits beginning with July 1, 2009. The first additional deposit was $1,000 and this decreased by $100 per deposit after that. The bank paid a nominal interest rate of 4% compounded quarterly through July 1, 2014. After July 1, 2014 it changed the nominal rate to 3.0% compounded monthly.

Immediately after making the last deposit (total 9 deposits), Sally decided to close out his account on July 1, 2016. Using Excel functions, determine how much money Sally received when she closed out the account.

Expert Solution

Using Excel functions

Effective interest rate till July 1,2014	4.060%
Effective interest rate after July 1,2014	3.042%
Date	Deposit
1 July,2008	500
1 July,2009	1000
1 July,2010	900
1 July,2011	800
1 July,2012	700
1 July,2013	600
1 July,2014	500
1 July,2015	400
1 July,2016	300

NPV of cash flow from Jul 1, 2008 to Jul 1,2014	4,484.56
NPV of cash flow from Jul 1, 2015 to Jul 1,2016	528.25
Total NPV	5,012.81
Future worth	12,923.48

Showing formula in excel

Effective interest rate till July 1,2014	=EFFECT(4%,4)
Effective interest rate after July 1,2014	=EFFECT(3%,12)
Date	Deposit
1 July,2008	500
1 July,2009	1000
1 July,2010	=F5-100
1 July,2011	=F6-100
1 July,2012	=F7-100
1 July,2013	=F8-100
1 July,2014	=F9-100
1 July,2015	=F10-100
1 July,2016	=F11-100

NPV of cash flow from Jul 1, 2008 to Jul 1,2014	=NPV(F1,F5:F10)+F4
NPV of cash flow from Jul 1, 2015 to Jul 1,2016	=PV(F1,6,,-(NPV(F2,F11:F12)))
Total NPV	=F14+F15
Future worth	=FV(F2,2,-FV(F1,6,,-F16))

Rahul Sunny answered 1 year ago

Dr. Laura Smith opened a medical practice specializing in physical therapy. During the first month of...

Dr. Laura Smith opened a medical practice specializing in physical therapy. During the first month of operation (July), the business, titled Dr. Laura Smith, Professional Corporation (P.C.), experienced the following events: LOADING... (Click the icon to view the events.) Read the requirements LOADING... . Requirement 1. Analyze the effects of these events on the accounting equation of the medical practice of Dr. Laura Smith, P.C.Begin with the first transaction on July 6. (Use parentheses or a minus sign when decreasing...

The infamous Hollywood liposuctionist, Dr. Tommy Tucker, has opened a new clinic in Beverly Hills on...

The infamous Hollywood liposuctionist, Dr. Tommy Tucker, has opened a new clinic in Beverly Hills on April 1,1999. From the following transactions, please prepare an operations statement and balance sheet 1. Dr Tucker puts $100,000 of his own money into the clinic 2. Dr Tucker prepaid his advertising in the amount of $9,500 3. Advertising expense for the month was $4,375 4. He purchased equipment for $50,000 in cash 5. Depreciation expense on the equipment was $400 6. Dr. Tucker...

a) On the first day of the month Javier opened a bank account in the name...

a) On the first day of the month Javier opened a bank account in the name of the business; in which I deposit $ 25,000. b) $ 600 was paid in cash for the month's rent. c) A used truck was purchased for $ 8,000 in cash. d) Tools were purchased for $ 3,000 on credit at Home Depot. e) $ 150 was paid in cash for the use of electric power. f) $ 1,500 was paid in advance for...

On November 30, 2001, Dr. Smith had a balance of $6,502.88 in his Cash Ledger account....

On November 30, 2001, Dr. Smith had a balance of $6,502.88 in his Cash Ledger account. On that date the bank statement indicated a balance of $8,243.75. Comparison of returned checks and bank memoranda revealed the following: 1. Deposits in transit November 30 amounted to $3,407. 2. Outstanding checks at November 30 totaled $2,140.37. 3. The Bank erroneously changed a $950 check of the Barkley Company against Dr. Smith's Bank account. 4. Bank service charges for November amounted to $20.00....

Below is data from a brokerage account Joyce opened eight (8) months ago. The first column...

Below is data from a brokerage account Joyce opened eight (8) months ago. The first column shows the ticker symbols for stocks she has purchased. 1. Solve for the missing values to be sure you know where the numbers come from. Given the info below, what was the previous closing price for SINA? 2. Let’s assume Joyce bought all of these stocks exactly nine months ago. If Costco declares and pays a dividend of $2.45 per share in that period,...

Dr. Chris EvensenChris Evensen opened a medical practice specializing in physical therapy. During the first month...

Dr. Chris EvensenChris Evensen opened a medical practice specializing in physical therapy. During the first month of operation (DecemberDecember), the business, titled Dr. Chris EvensenChris Evensen, Professional Corporation(P.C.), experienced the following events: LOADING... (Click the icon to view the events.) Read the requirements LOADING... . Requirement 1. Analyze the effects of these events on the accounting equation of the medical practice of Dr. Chris EvensenChris Evensen, P.C.Begin with the first transaction on DecemberDecember 6. (Use parentheses or a minus sign...

The First National Bank of Parkville recently opened up a new “So You Want to Be...

The First National Bank of Parkville recently opened up a new “So You Want to Be a Millionaire” savings account. The new account works as follows: The bank doubles the customer’s balance every year until the customer’s balance reaches one million. The customer isn’t allowed to touch the money (no deposits or withdrawals) until the customer’s balance reaches one million. If the customer dies before becoming a millionaire, the bank keeps the customer’s balance. Note:Customers close to $1,000,000 tend to...

You opened an account and deposited X Dollars on January 1, 2002 in National City Bank....

You opened an account and deposited X Dollars on January 1, 2002 in National City Bank. Any balance in the account will earn 5% per year. You withdrew $500 on January 1, 2006 and $500 on January 1, 2008. You closed out this account on January 1, 2011 and received $700. How much did you initially deposit (X) in National City at the time you opened the account?

Two accounts are opened at the same time. You deposit 1450 dollars into the first account,...

Two accounts are opened at the same time. You deposit 1450 dollars into the first account, which earns interest at an effective rate of 6.3 percent. At the same time, you deposit 260 dollars into the second account, which earns an effective rate of 11.8 percent. How long will it take for the balance in the first account to be exactly twice the balance in the second account? (Assume compound interest at all times.)

The following are national income account data for a hypothetical economy in billions of dollars: gross...

The following are national income account data for a hypothetical economy in billions of dollars: gross private domestic investment ($120); imports ($35); exports ($22); personal consumption expenditures ($2,460); and, government purchases ($470). What is GDP in this economy? A. $3,037 billion B. $3,290 billion C. $3,250 billion

Question