How are NET ASSETS calculated at the beginning of the years in cells B29 and D29

Question

How are NET ASSETS calculated at the beginning of the years in cells B29 and D29??
Week 13 Excel Workboakads to Home Insert Page Layout Formulas Dets Review View POF Tell me what you want to do Copy Font D24 4 Statements ofActivities 5 Common Size Ratios December 30, 2017 December 30, 2016 8 SUPPORT AND REVENUE 9 Contributions 10 Contributions of charitable gift annuities 11 Bequests 59.96% 4,771,172-7.44% 2,6sa,400 3.03% 241,245 0.50% 178,626; 27.38% 2,178,924 1 90.98% 32,436,803 12 Investment income-net Total support and revenue 100.00% 7,957,921 100.00% 35,6 499 16 EXPENSES 17 Program services 95.80% 6,053,675 1.36% 85,933 99.30% 34,754,236 0.22% 75,499; · 1181 Management and general 19 Fundraising 21 Total expenses 100,005.318.88S 100.00 24.998.051; CHANGE IN NET ASSETS BEFORE CHANGE IN UNREALIZED 23 APPRECIATION OF INVESTMENTS 20.60% 1,639,036 1.8496 6S6·448 CHANGE IN UNREALIZED 25 APPRECIATION OF INVESTMENTS soah 324.229 L20 h528159 27 CHANGE IN NET ASSETS 24.68%1,963,815 3.04% 1,084,607 fol 29 NET ASSETS-Beginning of year 81 NET ASSETS -End of year 32 9,245,913 34 35 NOTE: the 36 37 38 Interpretation: denominator needs to be the same for all numbers; in this case, total support and revenue 40 41 43 45 A. Common Size Balance Sheet A. Com. Size Activity Statement Ratios Parts B to G

Explanation / Answer

Net Assets-Beginning of the year in cell B29 and D29 have not been computed from the data in the image.

They must have been taken from Statement of Accounts (i.e. Balance Sheet) which does not form part of this image.Change in Net assets have been added to the Beginning Net Assets as per Balance Sheet to arrive at Closing Net Assets which would now be shown in the Balance sheet at current year end.

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.