Interest table create a spreadsheet to calculate how much a


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

Request for Solution File

Ask an Expert for Answer!!
Financial Management: Interest table create a spreadsheet to calculate how much a
Reference No:- TGS01423665

Expected delivery within 24 Hours