don't worry about the word problems at the bottom i just need the numbers.

this is all the information given and im not sure how the interest is supposed to be calculated.

Global Savings Bank (GSB) is examining the profitability of its Premier Account a combined savings and checking account (Click the icon to view account information) GSB recently conducted an activity-based costing study of its services. It assessed the following costs for six individual services. The use of these services in 2017 by three customers is as follows: (Click the icon to view the costs for the services and customer information Assume Linden and Garrad always maintain a balance above $1,000, whereas Skerrott always has a balance below $1,000 Read the requirements Requirement 1. Compute the 2017 profitability of the Linden Skertett, and Garrad Premier Accounts at GSB (For amounts with a 50 balance, make sure to enter "0 in the appropriate cell. Round your answers to the nearest cent Use parentheses or a minus sign for operating losses) Linden Skerrett Garrad Total Revenues Spread revenues on annual basis Monthly foo charges Total revenues Costs Deposit withdrawal with teller Deposit/withdrawal with ATM Deposit withdrawal on prearranged basis Bank checks written Foreign currency drafts Global Savings Bank (GSB) is examining the profitability of its Premier Account a combined savings and checking account (Click the icon to view account information GSB recently conducted an activity based costing study of its services. It assessed the following costs for sex individual services. The use of these services in 2017 by three customers is as follows (Click the icon to view the costs for the services and customer information ) Assume Linden and Garrad always maintain a balance above $1000, whereas Skerrett always has a balance below $1,000 Read the requirements LOGIN Foreign currency draits Inquiries Total costs Operating incomo (loss) Requirement 2. Why might GSB worry about the profitability of individual customers if the Premier Account product offering is profitable as a whole? across individual Premier Accounts occur when profits made on some accounts are V The account is highly pro table, while the account is szably unprofitable The account shows a small profit but only because of the V It is unlikely that will keep paying these high fees and that GSB would want them to pay such high fees from a customer relationship standpoint The facts also suggest that the customers w the bank services uniformly For example, ATM, and also inquire about their account balances more often than GSB have a lot of transactions with the teller or Competition likely would More Info -X se services in Depositors receive a 2% annual interest rate on their average deposit. GSB earns an interest rate spread of 3% (the difference between the rate at which it lends money and the rate it pays depositors) by lending money for home-loan purposes at 5%. Thus, GSB would gain $60 on the interest spread if a depositor had an average Premier Account balance of $2,000 in 2017 ($2,000 x 3% = $60) The Premier Account allows depositors unlimited use of services such as deposits, withdrawals, checking accounts, and foreign currency drafts. Depositors with Premier Account balances of $1,000 or more receive unlimited free use of services. Depositors with minimum balances of less than $1,000 pay a $25-a-month service fee for their Premier Account make sure to - i Data Table Account Usage Activity-Based Cost per "Transaction" $ 2.30 Linden Skerrett Garrad 42 56 7 0.70 9 22 16 050 0 15 62 12 1 7.80 4 Deposit/withdrawal with teller Deposit/withdrawal with automatic teller machine (ATM) Deposit/withdrawal on prearranged monthly basis Bank checks written Foreign currency drafts Inquiries about account balance Average Premier Account balance for 2017 6 3 12.10 5 6 130 7 20 $ 1,325 $ 900 S 24,800