Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The Science Road Show (SRS) is a not-for-profit organization that puts on traveling science demonstrations throughout the state. SRS operates on a September 1-August 31

The Science Road Show (SRS) is a not-for-profit organization that puts on traveling science demonstrations throughout the state. SRS operates on a September 1-August 31 fiscal year. The organization began FY 2018 with the following account balances:

Cash

40.000

Grants Receivable

100,000

Inventory

4,000

Notes Payable

50,000

Pledges Receivable, Net

10,000

PP&E, Net

75,000

Prepaid Rent

10,000

Unrestricted Net Assets

169,000

Wages Payable

20,000

The SRS recorded the following financial transactions during the FY 2018, which ended on August 31, 2018.

1. On September 1, SRS took out a $200,000 bank loan with an annual interest rate of 4.5%.SRSs prior outstanding loan has an annual interest rate of 6.0%.Annual interest payments on both loans are due August 31.

2. Halfway through the fiscal year, SRS used the new loan proceeds to purchase a new set that is expected to last 10 years and have no salvage value. SRS also recorded %5,000 in depreciation on its existing equipment, per its policy of recording depreciation annually.

3. On the first day of the fiscal year, SRS held a membership drive.Each 2-year membership is priced at $1,000 and entitles the member to benefits for 2 years.SRS sold an received payment for 50 memberships.

4. SRS sold $375,000 in tickets. All tickets were paid for in cash.

5. SRS received a $100,000 check for a foundation grant that was awarded in the previous fiscal years.At the end of FY 2018, SRS was awarded another $50,000 foundation grant.Payments on the second grant is expected in October 2018.

6. During the fiscal year, SRS received $60,000 in new donor pledges and collected 60% of the outstanding pledges from the previous fiscal year.Based on past experience, SRS expects that none of the remaining outstanding pledges from the prior fiscal year will be collected.

7. Throughout FY 2018, SRS ordered, paid for, and used $15,000 of program booklets.In August, SRS ordered (on account) $5,000 of programs for the following fiscal year.

8. SRSs employees earned $25,000 per month.Employees are paid with a 1-month lag.SRS also fully paid its prior-year obligations to employees.

9. Payments on SRSs leased vehicles and equipment are due 1 month in advance.In FY 2018, lease payments totaled $10,000 per month.In FY 2019, they will rise to $12,000 per month.

10. On August 31, in addition to making annual interest payments, SRS repaid the loan outstanding prior to FY 2018 in full.A $25,000 principle repayment on the loan taken out at the beginning of FY 2018 is due on September 1, 2018.

Record these events on the transactions worksheet using EXCEL and then create a 1)balance sheet, 2) activity statement, and 3) cash flow statement for FY 2018 on the pages that follow. by one by one transaction each

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions