Question

Exercise C10A: You are going to create a statement, by hand, using only the formulas on the chapter 10 chart (which we have lO.1 Inte Table 1 Deposits Withdrawals Interest Balance Date $100.00 1/1/16 $100.00 101.00 $1.00 102.01 1.01 1.02 103.03 10/1/

Exercise C10A: You are going to create a statement, by hand, using only the formulas on the chapter 10 chart (which we have looked at in class). The statement will display the information for a simple interest account for four years. You may NOT use Excel. If done correctly, the statement layout will look similar to Table 1 on page 431. The table that you create will have the following five columns: Date, Deposits, Withdrawals, Interest, and Balance. Fill in the appropriate dates (starting at the beginning of the account) when a deposit or withdrawal is made and/or when interest is earned. Fill in the appropriate values if any deposits are made, if any withdrawals are made, what interest is earned when interest is computed, and the balance at the end of the compound period. Create the statement that shows this information from the time of the initial deposit to the end of the six years for the following situation: On January 1, 2012, $26,471 was put into an account that earns 2.1% simple interest. The account is left alone to earn interest for the next six vears. Create a statement that shows the information about the account during the next four years (1/1/2012 to 1/1/2016). Note that you should have a balance of $28,694.56 on 1/1/2016
O.1 Inte Table 1 Deposits Withdrawals Interest Balance Date $100.00 1/1/16 $100.00 101.00 $1.00 102.01 1.01 1.02 103.03 10/1/16 104.06 1.03
0 0
Add a comment Improve this question Transcribed image text
Answer #1

lane AateAeposits 1112012 26,471 555.02306- 275%-46 山114 2759446 ケ67.56 27026 9oX2 1445 59.48 28133.94 27594, 46 x2. 591.085-

Add a comment
Know the answer?
Add Answer to:
Exercise C10A: You are going to create a statement, by hand, using only the formulas on the chapter 10 chart (which we...
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
  • Chapter 4 Financial Planning Exercise 6 Checking account reconciliation Use Worksheet 4.1. Carlos Perez has a...

    Chapter 4 Financial Planning Exercise 6 Checking account reconciliation Use Worksheet 4.1. Carlos Perez has a NOW account at the First State Bank. His checkbook ledger lists the following checks: Amount Check Numbers 654 658 $206.05 55.00 103.00 98.57 6.13 50.01 24.90 32.43 44.50 30.00 30.00 111.23 38.04 97.99 486.19 43.50 75.21 98.22 Carlos also made the following withdrawals and deposits at an ATM near his home: Date Amount Transaction 11/1 $50.00 withdrawal 11/2 $525.60 deposit 11/6 $100.00 deposit 11/14...

  • In this exercise, you will create an income statement, statement of owner’s equity, and balance sheet...

    In this exercise, you will create an income statement, statement of owner’s equity, and balance sheet in Excel for Ampersand Co. With the exception of the Robert Benjamin, Capital account (the balance for which is from 2/1/2016), the company had the following account balances as of 2/29/2016: Notes Payable $1,200 Service Revenue $26,600 Robert Benjamin, Drawing $1,500 Furniture $4,800 Building $18,000 Robert Benjamin, Capital – 2/1/2016 $16,300 Telephone Expense $3,000 Accounts Receivable $7,200 Office Expense $3,400 Utilities Expense $2,200 Interest...

  • 8-One year from now, you deposit $300 in a savings account. You deposit $1,800 the next...

    8-One year from now, you deposit $300 in a savings account. You deposit $1,800 the next year. Then you wait two more years (until 4 years from now) and deposit $1,000. If your account always earns 6% annual interest and you make no withdrawals, how much will be in the account 11 years from now? 9-You deposit $5000 for 5 years at 4% annual interest. In 5 years, you add $15,000 to your account, but the rate on your account...

  • (Note: The problem statement should include another deposit of $X two years ago to be matching...

    (Note: The problem statement should include another deposit of $X two years ago to be matching with the provided Cash Flow Diagram). 2.72 Four years ago, you opened a mutual fund account and made three deposits ($100 four years ago, SX three years ago, and $200 a year ago) where you earned varying interest rates, according to the diagram that follows. Today 8 CHAPTER 2 Time Value of Money your balance shows $800. Determine the amount of the deposit made...

  • In this exercise, you will create an income statement, statement of owner’s equity, and balance sheet...

    In this exercise, you will create an income statement, statement of owner’s equity, and balance sheet in Excel for Dragon, Inc. With the exception of the William Moss, Capital account (the balance for which is from 8/1/2016), the company had the following account balances as of 8/31/2016: Supplies Expense $1,800 Cash $65,300 William Moss, Capital – 8/1/2016 $73,200 Sales Revenue $33,000 Land $20,000 Accounts Payable $3,000 Accounts Receivable $1,600 Equipment $12,000 Utilities Expense $1,900 Telephone Expense $2,000 Office Expense $2,100...

  • 1. On May 2, you receive your bank statement showing a balance of $1,641.18. Your checkbook...

    1. On May 2, you receive your bank statement showing a balance of $1,641.18. Your checkbook shows a balance of $1,427.15. Outstanding checks are $167.31, $245.66, and $302.56. The account earned $62.11. Deposit in transit amount to $555.61, and there is a service charge of $8.00. Calculate the reconciled balance. CHECKBOOK BALANCE STATEMENT BALANCE Add: Interest Earned & Other Credits Add: Deposits in Transit SUBTOTAL SUBTOTAL Deduct: Services Charges & Other Debits Deduct: Outstanding Checks ADJUSTED CHECKBOOK BALANCE ADJUSTED STATEMENT...

  • the programing language is C++ TIC PEO. Design a generic class to hold the following information...

    the programing language is C++ TIC PEO. Design a generic class to hold the following information about a bank account! Balance Number of deposits this month Number of withdrawals Annual interest rate Monthly service charges The class should have the following member functions: Constructor: Accepts arguments for the balance and annual interest rate. deposit: A virtual function that accepts an argument for the amount of the deposit. The function should add the argument to the account balance. It should also...

  • Four years ago, you opened a mutual fund account and made three deposits ($200 four years ago, SX...

    Four years ago, you opened a mutual fund account and made three deposits ($200 four years ago, SX three years ago, and $300 a year ago) where you earned varying interest rates according to the following diagram. Today, your balance shows $1,000. Determine the amount of deposit that was made three years ago (SX). See the following figure (a) $215 (b) $237 (c) $244 (d) $259 F $1,000 6% 8% 12% 15% -1 0 $200 $300 Four years ago, you...

  • Shamrock, Inc.'s bank statement from Main Street Bank at August 31, 2022, gives the following information....

    Shamrock, Inc.'s bank statement from Main Street Bank at August 31, 2022, gives the following information. Balance, August 1 $18,590 Bank debit memorandum: August deposits 71,190 Safety deposit box fee $90 Checks cleared in August 68,613 Service charge 115 Bank credit memorandum: Balance, August 31 21,072 Interest earned 110 A summary of the Cash account in the ledger for August shows the following: balance, August 1, $18,890; receipts $74,190; disbursements $73,505; and balance, August 31, $19,575. Analysis reveals that the...

  • Sage Hill Inc.’s bank statement from Main Street Bank at August 31, 2022, gives the following...

    Sage Hill Inc.’s bank statement from Main Street Bank at August 31, 2022, gives the following information. Balance, August 1 $18,635 Bank debit memorandum: August deposits 71,235 Safety deposit box fee $ 40 Checks cleared in August 68,663 Service charge 65 Bank credit memorandum: Balance, August 31 21,162   Interest earned 60 A summary of the Cash account in the ledger for August shows the following: balance, August 1, $18,935; receipts $74,235; disbursements $73,555; and balance, August 31, $19,615. Analysis reveals...

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