How to calculate ‘change in unrealized appreciation of investments’ for cells B2

Question

How to calculate ‘change in unrealized appreciation of investments’ for cells B25 and D25?? File Home Insert Page Layout Formulas Data Review View PDF Tell mewh Verdana 10A A Wrap Text Perce Copy Format Painter Clipboard Font 823 8 SUPPORT AND REVENUE: 59.96%(4,771,172-1.7 10 Contributions of charitable gift anmuaities 11 Bequests 12 Investment incomenet 2,654,400 178,626 90.98% 32,436,803 1,0896 384.670 0.50 3.03% 241,245 27.38% 2,178,924 9,63% 766,580 | | 14 Total support and revenue 100.00% 7,957,921 100.00% 35,654,499 16 EXPENSES: 17 Program services 18 Management and general 19 Fundraising 95.80% 6,053,675 1 1 99.30% 34,754,236 1.36% 85,933 0.22% 75,499 2.84% 179,277 0.4896 168,316 21 Total expenses 100.00% 6.318.885 , 100.00% 34,998,051 CHANGE IN NET ASSETS BEFORE CHANGE IN UNREALIZED 23 APPRECIATION OF INVESTMENTS 24 1,639,036 656,448 CHANGE IN UNREALIZED 25 APPRECIATION OF INVESTMENTS 27 CHANGE IN NET ASSETS 1,963,815 1,084,607 29 NET ASSETS Beginning of year 30 31 NET ASSETS-End of year 32 34 9.245,913 7,282,098 35 NOTE: the denominator needs to be the same for all numbers; in this case, total support and reven 36 37. A. Common Size Balance Sheet A. Com. Size Activity Statement Ratios Parts B to C Ready

Explanation / Answer

For B 25 it is 4.08%, calculated : C 25 divided by C 14

For D 25 it is 1.20%, calculated : E 25 divided by E 14

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

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