Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

i almost finished all of it i just want to know if it is rigth, and also help in what I havent done AutoSave O

i almost finished all of it i just want to know if it is rigth, and also help in what I havent done image text in transcribed
image text in transcribed
image text in transcribed
AutoSave O 2 B F Project 1 Basic Excel Wilhelm $20 2.1... Saved File Home Insert Draw Page Layout Formulas Data Review View Help Calibri === 11 AA Paste ABTUEA Clipboard Font General $ % 8 % Alignment s Number 146 1 P4-1A Record transactions on accrual basis, convert revenue to cash receipts 2. The following selected data are taken from the comparative financial statements of Yankee 3 Curling Club. The club prepares its financial statements using the accrual basis of accounting September 30 Accounts receivable for member dues Unned sales revenue Service revenue (from member dues) 2017 $ 15.000 20,000 151.000 2016 $ 19.000 23.000 135 000 10 Dues are billed to members based upon their use of the club's faces Ungarned sales 11 revenues arise from the sale of tickets to avots, such as the Skins Game 13 Instructions 1 it. You will find it helpful to use accounts to analyze the following data. You must 15 analyze these dala sequently, as missing information must first be deduced before 16 moving on) 17 (a) Use the table summary that includes selected accounts and balances to record the following events that took place during 2017 1 Dues receivable from members from 2016 were all collected during 2017 2 During 2017. goods were provided for all of the uncanned sales revenue at the end of 2016 3. Additional tickets were sold for $14.000 cash during 2017. a portion of these were used by the purchases during the year The entire balance remaining in Uneamed Sales Revente relates to the upcoming Skins Game in 2017 4 Dues of $151,000 for the 2016-2017 fiscal year were bed to members 5 Dues receivable for 2017 6 those bibed in tem (4) above) were partially collected Determine the amount of cash received by Yankee from the above transactions during the year onded Sember 30, 2017 2 NOTE: Enter a number in cells requesting a value enter either a number or a formula in cells with a YANKEE CURLING CLUB E O RI e I Home Insert Draw Page Layout Formulas Data Review View Help Calibri 11 AA == BIU BOA General $ - %) - 8-98 Cond Format oards Fonts Alignment Number Sales Revenue relates to the upcoming Skars Game in 2017 4 Dues of $150 000 for the 2016-2017 biscal year were biled to members 5. Dues receivable for 2017(e. those billed in item (4) above) were partially collected Determine the amount of cash received by Yankee from the above transactions during the year ended September 30, 2017 WOTL: Enter a number in cells requesting a value enter ther a number or a formula in cells with a YANKEE CURLING CLUB Las Sales Rev 10/2016 519.000 151000 -1000 1 Formula Page Layout File Home Insert Draw General 1 AA Calibri 5 % 9 68 * Condo Formatti - Number Alignment Cath e d wh respect to fees and des 1 Cachon of 2015 dues 5 Cocon 2017 dues 151000 19000 4000 5097 199 000 5016 19.000 135 000 2017 15000

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

Care And Counsel For Combat Trauma Training Program Workbook For Audit Only

Authors: Cru Military, American Association Of Christian Counselors, Light University, Karen D Watkins

1st Edition

ISBN: 0986363081, 978-0986363085

More Books

Students also viewed these Accounting questions