A
Anthony
The Project
Nations Bank has 7 customers (make up your own names, put
your name as the first) holding a saving account that pays
interest each month at the annual rate of 8% (monthly rate
is then 8/12%) and charges $2.00 each month for service.
The balances in these accounts at the end of January are:
$1250, $475, $85.30, $274.90, $342.40, $266.25 and $2469.20
Enter these data in an Excel spreadsheet and use the
features of Excel to compute and display interest for
January and the balance after adding the January interest
and taking off the service charge (four columns). Print
the spreadsheet and the formulae. Beginning balance for
the month of February for the same customers are:
$820, $932.50, $1342.20, 365.00, 125.00, 3412.10, 1194.30
Make the least neccessary changes to the above spreadsheet
to display the February ending balance for these
customers. Print this spreadsheet also (not the formulas).
Nations Bank has 7 customers (make up your own names, put
your name as the first) holding a saving account that pays
interest each month at the annual rate of 8% (monthly rate
is then 8/12%) and charges $2.00 each month for service.
The balances in these accounts at the end of January are:
$1250, $475, $85.30, $274.90, $342.40, $266.25 and $2469.20
Enter these data in an Excel spreadsheet and use the
features of Excel to compute and display interest for
January and the balance after adding the January interest
and taking off the service charge (four columns). Print
the spreadsheet and the formulae. Beginning balance for
the month of February for the same customers are:
$820, $932.50, $1342.20, 365.00, 125.00, 3412.10, 1194.30
Make the least neccessary changes to the above spreadsheet
to display the February ending balance for these
customers. Print this spreadsheet also (not the formulas).