Please show all formulas used for Savings Balance, Interest Earned, Savings New

Question

Please show all formulas used for Savings Balance, Interest Earned, Savings New Balance, Checking Balance, Transfer Amount, and Checking New Balance for the first 3 rows of the data table.

The worksheet should be setup as shown at the end of this document. Allow the user to change the initial balance of the accounts, any transaction information, or the interest table and have the entire spreadsheet update. Savings New Balance is the Savings Balance, plus or minus the Transaction Amount, plus the Interest Earned. Checking New Balance is Checking Balance plus or minus the Transaction Amount plus the Transfer Amount. You will need to write a calculation for Savings Balance, Interest Earned, Savings New Balance, Checking Balance, Transfer Amount, and Checking New Balance. The interest table determines what interest rate a Savings account earns based on that account's balance. There are three brackets: High, Mid, and Low. In the example below, you earn 2.00% interest if you have at least $10,000.01 in your account, you earn 1.00% interest if you have at least $5,000.01 in your account, and you earn 0.50% interest otherwise. Interest is calculated before a transaction is applied. You must reference the table in the interest calculation so that any changes to the table will change your calculations automatically. The Checking account does not earn interest.

Explanation / Answer

Please find the formulas used for Savings Balance, Interest Earned, Savings New Balance, Checking Balance, Transfer Amount, and Checking New Balance

Savings Balance = Last day/last row New savings balance

Interest Earned = Savings Balance * Interest rate (2% or 1% or 0.5%)

Savings New Balance = Savings Balance + Deposits - Withdrawal - Transfer + Interest Earned

Checking Balance = Last day/last row New Checking balance

Transfer Amount = Add to Checking Account

Checking New Balance = Checking balance + Transfer amount + Deposit - Withdrawal

Savings balance T type T amount Interest Savings New Balance Checking balance T type T amount Transfer Checking new balance 10000 W 800 100 (10000 * 1%) 9300 (10000 - 800 +100) 1000 W 900 0 100 (1000 - 900) 9300 D 100 93 (9300 * 1%) 9493 (9300 + 100+93) 100 D 312 0 412 (100 + 312) 9493 T 1200 94.93 (9493 * 1%) 8387.93 (9493 - 1200+94.93) 412 D 90 1200 1702 (412 + 90+1200) 8387.93 W 300 83.88 (8387.93 * 1%) 8171.88 (8387.93 - 300+83.88) 1702 W 30 0 1672 (1702 - 30)

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.