Verdana Copy .Format Painter & Center . Clipboard Font E29 B C Problem 14.11 3 S
ID: 2586999 • Letter: V
Question
Verdana Copy .Format Painter & Center . Clipboard Font E29 B C Problem 14.11 3 SOLUTION 5 PART A. CODE 4 CHANGE 8 Statements of Financial Position 9 Common Size Ratios 10 December 30, 2017 December 30, 2016 12 13 ASSETS 14 CASH AND CASH EQUIVALENTS 15 INTEREST AND DIVIDENDS RECEIVABLE 14.35% 1,909,606 0.46% 61,244 2.81% 373,788 9.38% 1,044,193 0.47%-52,582 3.22% 358,632 0.23% 25,367 86 70 2.653.029 16 CAMPAIGNS PLEDGES RECEIVABLE 17 PREPAID EXPENSES AND OTHER 0.12% 16,244 .. B2.2010.944.924 18 INVESTMENTS 19 20 TOTAL 21 22 LIABILITIES AND NET ASSETS 23 LIABILITIES 24 Accounts payable-DAV 25 Accounts payable-other 26 Annuity payment Eability 100.00% 13,305,806 100.00% 11,133,813; 1.54% 171,550 910 0.01% 1,017 28.99% 3.857.262 33.04% 3.679.148 201,721 1.52% 0.01% 30.51% 4,059,893 34.59% 3,851,715; 59.49% 9.245.913 5,41 7,282,098 100.00% 13,305,806 100.00% 11,133,813. Total liabilities 27 28 UNRESTRICTED NET ASSETS 30 31 TOTAL LIABLITIES and NET ASSETS 32 34 NOTE: the denominator needs to be the same for all numbers; in this case, total assets 35 36 37 Interpretation 38 40 43 A. Common Size Balance Sheet A. Com. Size Activity Statement Ratios Parts B to GExplanation / Answer
Vertical Analysis Balance Sheet Common Size Balance Sheet Assets 2017 Percent % 2016 Percent % Current Assets Cash $ 1,909,606.00 14.35 $ 1,044,193.00 9.38 Interest and dividend receivable $ 61,244.00 0.46 $ 52,582.00 0.47 Compaigns pledges receivable $ 373,788.00 2.81 $ 358,632.00 3.22 Investment $ 10,944,924.00 82.26 $ 9,653,039.00 86.70 Prepaid Expenses and Other Items $ 16,244.00 0.12 $ 25,367.00 0.23 Total Current Assets $ 13,305,806.00 100.00 $ 11,133,813.00 100.00 Liabilities and Net Asset Liabilities Accounts Payable-DAV $ 201,721.00 1.52 $ 171,550.00 1.54 Accounts Payable-Other $ 910.00 0.01 $ 1,017.00 0.01 Annuity Payment -Liability $ 3,857,262.00 28.99 $ 3,679,148.00 33.04 Total Liabilities $ 4,059,893.00 30.51 $ 3,851,715.00 34.59 Unrestricted Net Assets $ 9,245,913.00 69.49 $ 7,282,098.00 65.41 Total Liabilities and Net assets $ 13,305,806.00 100.00 $ 11,133,813.00 100.00 Working B C D E F 28 Assets 2017 Percent % 2016 Percent % 29 Current Assets 30 Cash $ 1,909,606.00 (C30/C35)*100 $ 1,044,193.00 (E30/E35)*100 31 Interest and dividend receivable $ 61,244.00 (C31/C35)*100 $ 52,582.00 (E31/E35)*100 32 Compaigns pledges receivable $ 373,788.00 (C32/C35)*100 $ 358,632.00 (E32/E35)*100 33 Investment $ 10,944,924.00 (C33/C35)*100 $ 9,653,039.00 (E33/E35)*100 34 Prepaid Expenses and Other Items $ 16,244.00 (C34/C35)*100 $ 25,367.00 (E34/E35)*100 35 Total Current Assets $ 13,305,806.00 (C35/C35)*100 $ 11,133,813.00 (E35/E35)*100 36 37 Liabilities and Net Asset 38 Liabilities 39 Accounts Payable-DAV $ 201,721.00 (C39/C44)*100 $ 171,550.00 (E39/E44)*100 40 Accounts Payable-Other $ 910.00 (C40/C44)*100 $ 1,017.00 (E40/E44)*100 41 Annuity Payment -Liability $ 3,857,262.00 (C41/C44)*100 $ 3,679,148.00 (E41/E44)*100 42 Total Liabilities $ 4,059,893.00 (C42/C44)*100 $ 3,851,715.00 (E42/E44)*100 43 Unrestricted Net Assets $ 9,245,913.00 (C43/C44)*100 $ 7,282,098.00 (E43/E44)*100 44 Total Liabilities and Net assets $ 13,305,806.00 D42+D43 $ 11,133,813.00 SUM(F42:F43) Unrestricted Net assets are those assets which can be utilized for any purpose by Govt body of a company Change in Net assets before change in Unrealized apreciation of investment in 2017=Total Support and revenue-Total Expenses=($7957921-$6318885)=$1639036 $ 1,639,036.00 Add: Change in Unrealized appreciation of investment $ 324,779.00 Change in Net assets=($1639036+$324779) $ 1,963,815.00 Add: Beginning Net Assets $ 7,282,098.00 Unrestricted Net Assets=($1963815+$7282098) $ 9,245,913.00 % of Unrestricted Net assets=($9245913/$13305806)*100 69.49% Change in Net assets before change in Unrealized apreciation of investment in 2016=Total Support and revenue-Total Expenses=($35654499-$34998051)=$656448 $ 656,448.00 Add: Change in Unrealized appreciation of investment $ 428,159.00 Change in Net assets=($658448+428159) $ 1,084,607.00 Add: Beginning Net Assets $ 6,197,491.00 Unrestricted Net Assets=($1963815+$7282098) $ 7,282,098.00 % of Unrestricted Net assets=($7282098/$11133813)*100 65.41%
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.