Question
Interest Table: Create a spreadsheet to calculate how much a deposit of $1,000 would be worth if left in a bank for ten years at
Interest Table: Create a spreadsheet to calculate how much a deposit of $1,000 would be worth if left in a bank for ten years at 6.5 percent annual interest. Show princi- pal and interest for each year as follows: Annual Interest Rate: .065 YEAR PRINCIPAL INTEREST 1 $1,000.00 (a) 2 (b) At the bottom of the PRINCIPAL column, create a line sparkline to show its growth. NOTE: Note that the interest in cell (a) is the principal to its left times the absolute reference to the cell that contains .065. The new principal in cell (b) is the old principal plus the interest in the row above it. Can i get assistance o n how to do the calculations on the excel spread sheet for. i am stuck
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started