needs to be done using excel

1. PNC Bank pays 5% simple interest on its savings account balances, whereas First Niagara Bank pays 5% interest compounded annually. If you made a deposit of $20,000 in each bank, how much money would you earn from both bank accounts at the end of 10 years? You are called by Tim Duncan of Spurs Co. on July 16 and asked to prepare a claim for insurance as a result of a theft that took place the night before. You suggest that an inventory be taken immediately. The following data are available $ 38,000 85,000 Inventory, July 1 Purchases-goods placed in stock July 1-15 Sales revenue-goods delivered to customers (gross) Sales returns-goods returned to stock 116,000 4,000 Your client reports that the goods on hand on July 16 cost $30,500, but you determine that this figure includes goods of $6,000 received on a consignment basis. Your past records show that sales are made at approximately 40% over cost Duncan's Insurance covers only goods owned Compute the claim against the insurance company. (Round gross proft percentage to 2 decimal places, es 78.73% and final answer to decimal places, s. 28,987) Claim against the insurance company 23003