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.

Solutions

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 4 weeks ago

Next > < Previous

Related Solutions

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...

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.)

Email from Suresh Batik I received the following email from a former student. I hope you...

Email from Suresh Batik I received the following email from a former student. I hope you are doing well. I took your Managerial Accounting class ten years ago and have a question on how to do costing in a service-based business. Currently, I am working for a firm that manufactures various products used in pipelines (torque wrenches, flange pullers, bolts and flanges, grinding machines, etc.). Five years ago we began servicing pipelines in refineries, offshore/onshore platforms, nuclear plants, etc. Our...

Old Economy Traders opened an account to short sell 1,600 shares of Internet Dreams at $52...

Old Economy Traders opened an account to short sell 1,600 shares of Internet Dreams at $52 per share. The initial margin requirement was 50%. (The margin account pays no interest.) A year later, the price of Internet Dreams has risen from $52 to $60, and the stock has paid a dividend of $2.00 per share. a. What is the remaining margin in the account? (Omit the "$" sign in your response.) Remaining margin $ b. If the maintenance margin requirement...

Subjects