Homework answers / question archive / 1) Open up a new Excel file and save as "Internship Assessment June2021" 2

1) Open up a new Excel file and save as "Internship Assessment June2021" 2

MS Excel

Share With

1) Open up a new Excel file and save as "Internship Assessment June2021" 2. Create your own spreadsheet to support the following transactions from the first half of the Fiscal Year. a. On 7/1/19 we received a $1,000.00 donation to the ABC Scholarship (Fund# 101). b. On 7/1/19 we paid $5,185.00 on a loan from ABC Bank from our Unrestricted Fund (Fund# 100). c. On 7/15/19 we paid $1,353.00 in taxes to the City of Worcester from our Unrestricted Fund. d. On 7/20/19 we received the following donations: i. $500,000.00 to the John Smith Estate Fund (Fund# 150). ii. $10,000.00 to the General Scholarship Fund (Fund# 105). iii. $100.00 to the Unrestricted Fund. iv. $5,000.00 to the ABC Scholarship Fund. e. On 8/1/19 we paid $5,185.00 on a loan from ABC Bank from our Unrestricted Fund. f. On 8/10/19 we paid $400,000.00 from the General Scholarship Fund to student bills. g. On 8/20/19 we received $15,000 to our Alumni Golf Scholarship Fund (Fund# 151). h. On 9/1/19 we paid $5,185.00 on a loan from ABC Bank from our Unrestricted Fund. i. On 9/2/19 we received a $485,000.00 donation from an insurance policy payout from a deceased constituent to the Unrestricted Fund. j. On 9/18/19 we paid $3,855.00 for new microscopes and supplies for the Biology Research Team out of the Science Research Fund (Fund# 172). k. On 10/1/19 we paid $5,185.00 on a loan from ABC Bank from our Unrestricted Fund. I. On 10/12/19 we received $4,000.00 for the Adopt-a-Scholar Fund (Fund# 155). m. On 10/30/19 we received $500.00 for the Adopt-a-Scholar Fund. n. On 11/1/19 we paid $5,185.00 on a loan from ABC Bank from our Unrestricted Fund. o. On 11/14/19 we paid $500.00 each for 2 students to attend a conference in Boston from the CSD Fund (Fund # 185). p. On 11/20/19 we received $1,000.00 to the General Scholarship Fund. q. On 12/1/19 we paid $5,185.00 on a loan from ABC Bank from our Unrestricted Fund. r. On 12/10/19 we received $2000.00 for the Adopt-a-Scholar Fund. s. On 12/21/19 we received a $10,000.00 grant for the Technology Fund (Fund# 192). t. On 12/30/19 we received $1,000.00 for the Unrestricted Fund. 3. Now that you have all the transactions in Excel, please create two separate summary sheets to report donations and expenses to our Board members. a. Summarize donations and expenses on separate tabs. b. Summarize by fund c. Use formulas when summarizing and not values. 4. On a separate tab, please calculate the ending balance of the Unrestricted Fund on 12/31/19. The opening balance on 7/1/19 for the Unrestricted Fund was $2,056,450.00. 5. Make sure all sheets/tabs that you created are labelled. 6. Make any formatting changes as you see necessary.