I need help with my workbook assignment. Specifically I need to know if my numbers are correct thus far. Also I need help understanding the budget and analysis tabs. Thank you
AutoSave Off H ACC 325 Final Project Workbook Search CS File Home Insert Draw Page Layout Formulas Data Review View Help Acrobat Share Comments NT Calibri 11AA ab Currency a Wrap Text DIT I MTT AY O W 5 TA Paste BIU A y Ideas $ %) 4-20 EE E Merge & Center Insert Delete Format Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Clipboard Font Alignment Number Cells Editing Ideas A B21 fac =SUM(B17:B20) B c D E F G H H - J K L M N $156,500.00 36,900.00 2,800.00 178,000.00 90,000.00 $464,200.00 A 2 Statement of Financial Position 3 December 31, 2018 4 Assets 5 Cash 6 Pledges Receivable 7 Inventory 8 Investments 9 Furniture and Equipment 10 11 Total Assets 12 Liabilities 13 Accounts Payable 14 15 Total Liabilities 16 Net Assets 17 Without Donor Restrictions 18 With Donor Restrictions-Programs 19 With Donor Restrictions-Permanent Endowment 20 21 Total Net Assets 22 Total Liabilities and Net Assets $20,520.00 $20,520.00 $196,500.00 50,500.00 140,000.00 $387,000.00 $407,520.00 23 Trial Balance Statement of Financial Position Statement of Activities Statement of Cash Flows Budget Financial Analysis Ready 3 + 100% ry e 4:08 PM 8/16/2020 AutoSave ACC 325 Final Project Workbook ... Search File Home Insert Draw Page Layout Formulas Data Review View Help Acrobat Share Comments CIT Calibri a Wrap Text Currency - 11 AA == A W AY O 5 Paste BIU Ideas - 3 Merge & Center Insert Delete Format $ %) Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Clipboard Font Alignment Number Cells Editing Ideas C23 X fic =+C9-C22 D E F G H - With Donor Restrictions Total 5 $38,1001 $416,9201 11,200 $38,100 $428,120 B Without Donor 4 Restrictions Revenues, Gains, and Other Support: 6 Contributions $378,820 7 Investment Income 11,200 8 9 Total Revenues, Gains, and Other Support $390,020 10 Expenses and Losses: 11 Program Services: 12 Program 1 142,576 13 Program 2 74,288 14 Program 3 40,144 15 16 Total Program Expenses $257,008 17 Support Expenses: 18 Management and General 74,288 19 Fundraising 40,144 20 21 Total Support Expenses $114,432 22 Total Expenses and Losses 371,440 23 Change in Net Assets $390,020 24 Net Assets, December 31, 2017 Trial Balance Statement of Financial Position 142,576 74,288 40,144 $0 $257,008 74,288) 40,144 $0 0 $38,1001 $114,432 371,440 $428,1201 Statement of Activities Statement of Cash Flows Budget Financial Analysis Ready 100% ' o x 4:09 PM 8/16/2020 AutoSave Off H ACC 325 Final Project Workbook O Search CS File Home Insert Draw Page Layout Formulas Data Review View Help Acrobat Share Comments NT Calibri 11 A A == ab Wrap Text General CIT I MTT o W TA Paste BIU EE E Merge & Center Insert Delete Format y $ %) 48.8 A Ideas Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Editing Clipboard Font Alignment Number Cells Ideas A C26 X D E F H L M. N O P - A B 7 Cash Paid to Employees -288,410 8 Cash Paid for Operating Expenses -86,504 9 10 Net Cash Used for Operating Activities -$22,914 11 Cash Flows from Investing Activities: 12 Purchase of Furniture and Equipment -22,000 13 Cash Flows from Financing Activities: 14 Proceeds from Contributions Restricted for: 15 Investment in Capital Assets 38,100 16 Net Increase(Decrease) in Cash -6,814 17 Cash, December 31, 2017 163,314 18 Cash, December 31, 2018 $156,500 19 20 Reconciliation of Changes in Net Assets to Net Cash Used for 21 Change in Net Assets $428,120 22 Adjustments to Reconcile Changes in Net Assets to Net Cash 23 Depreciation -30,000 24 Increase in Net Pledges Receivable 6,000 25 Increase in Inventory 1,000 26 Decrease in Accounts Payable -102,594 27 28 Net Cash Used for Operating Activities $428,120 Trial Balance Statement of Financial Position Screenshot saved The screenshot was added to your OneDrive. Statement of Activities Statement of Cash Flows Budget Financial Analysis OneDrive Ready HE B 100% nay e - g ( 4:09 PM 8/16/2020 AutoSave Off H ACC 325 Final Project Workbook Search CS File Home Insert Draw Page Layout Formulas Data Review View Help Acrobat Share Comments NT Calibri ab Wrap Text Currency CIT I MTT - 11 VA A == CA AY O W TA 5 Paste E E Merge & Center $ %) 4-20 Insert Delete Format Ideas Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Clipboard Font Alignment Number Cells Editing Ideas A C7 X D E F H 1 J L M N o P 1 A B
Budget January 1, 2019 - December 31, 2019 2 3 4 5 YTD Actual 2018 $378,820 Budget 2019 6 38,100 7 Contributions-Without Donor Restrictions Contributions-With Donor 8 Restrictions-Programs 9 Investment Income-Without Donor Restrictions 10 Depreciation Expense 11 Printing and Publishing Expense 12 Rent and Utility Expense 13 Salaries and Fringe Benefit Expense 14 Supplies Expense 15 Telephone and Postage Expense 16 Utilities Expense 17 Change in Net Assets 18 11,200 -30,000 -4,190 -32,000 -288,410 -5,940 -4,500 -6,400 $799,560 $0 19 20 Screenshot saved The screenshot was added to your OneDrive. 21 Trial Balance Statement of Financial Position Statement of Activities Statement of Cash Flows Budget Financial Analysis OneDrive Ready HE B 100% nay e a x () 4:09 PM 8/16/2020 AutoSave Off H ACC 325 Final Project Workbook Search CS File Home Insert Draw Page Layout Formulas Data Review View Help Acrobat Share Comments Calibri 11 AA == ab Wrap Text General CIT I MTT AY O W 5 TA Paste BIU A y $ %) 4-20 EE E Merge & Center Insert Delete Format Ideas Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Clipboard Font Alignment Number Cells Editing Ideas J18 X A D F F G H K - M L N o P B Liquidity 1 2 : = Ratio Numerator Current Assets Denominator Current Liabilities 3 4 = #DIV/0! 5 6 Going Concern 7 = Ratio Numerator Total Revenues Denominator Total Expenses 8 9 . #DIV/0! 10 11 Capital Structure Ratio 12 13 14 Numerator Debt Denominator Total Assets + #DIV/0! 15 16 Debt + Net Assets 17 #DIV/0! 18 19 20 Numerator Ratio Program Effectiveness Denominator Total Expenses 21 22 Program Expenses Screenshot saved The screenshot was added to your OneDrive. #DIV/0! Trial Balance Statement of Financial Position Statement of Activities Statement of Cash Flows Budget Financial Analysis OneDrive Ready HE B 100% nay e - g ( 4:09 PM 8/16/2020 AutoSave Off H ACC 325 Final Project Workbool O Search CS File Home Insert Draw Page Layout Formulas Data Review View Help Acrobat Share Comments NT Calibri 11AA === CIT I MTT General 280 TA a Wrap Text E E Merge & Center WO Paste BIU A $ %, 809 Insert Delete Format y Ideas Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Clipboard Font Alignment Number Cells Editing Ideas A A2 X fac Trial Balance A D E F F G H 1 J L M N o P 5 Cash 6 Pledges Receivable-Without Donor Restrictions 7 Estimated Uncollectible Pledges 8 Inventory 9 Investments 10 Furniture and Equipment 11 Accumulated Depreciation-Furniture and Equipment 12 Accounts Payable 13 Net Assets Without Donor Restrictions 14 Net Assets With Donor Restrictions-Programs 15 Net Assets With Donor Restrictions-Permanent Endowment 16 Contributions-Without Donor Restrictions 17 Contributions-With Donor Restrictions-Programs 18 Investment Income-Without Donor Restrictions 19 Depreciation Expense 20 Printing and Publishing Expense 21 Rent Expense 22 Salaries and Fringe Benefit Expense 23 Supplies Expense 24 Telephone and Postage Expense 25 Utilities Expense 26 Totals B $156,500 41,000 $4,1001 2,800 178,000 210,000 120,000 20,5201 196,500 50,500 140,000 378,820 38,100 11,200 30,000 4,190 32,000 288,410 5,940 4,500 6,400 $959,740 $959,740 7 Trial Balance Statement of Financial Position Statement of Activities Statement of Cash Flows Budget Financial Analysis Ready 3 + 100% nay | 1 o 4:08 PM 8/16/2020
