USING THE SAMPLE FINANCIAL REPORTING PACKAGE PDF, ANSWER THIS QUESTION: | | |
| | | | | | | | | | |
| | | | | | | | | | |
If you were this firms accountant / analyst, what would you tell them based on the package information? |
Balance Sheet - YTD Jan 2021 Feb 2021 Mar 2021 Apr 2021 May 2021 Jun 2021 Jul 2021 Aug 2021 Sep 2021 Oct 2021 Nov 2021 Dec 2021 Total $82,503 $193,665 $67,892 $344,060 $5,563 $5,563 $349.623 $109.463 $190,618 $225,519 $525,599 $5,563 $5,563 $531,162 $143,183 $186,140 $226,215 $555,538 $5,563 $5.563 $166,213 $204,505 $230,544 $601,262 $5,563 $5,563 $606.824 $170,888 $170,872 $225,894 $567,654 $5,563 $5,563 $165.927 $151,891 $218.941 $536,759 $5,563 $5,563 $542,322 $153,695 $120,685 $206,286 $480,666 $5,563 $5.563 $486,229 $149,566 $114,985 $199,304 $463,855 $5,563 $5,563 $147,834 $101,072 $190.158 $439,065 $5,563 $5,563 $147.834 $101,072 $190.158 $439,065 $5.563 $5,563 $561,101 $573,217 $469,418 $444,628 $444,628 $61,789 BALANCE SHEET ASSETS Cash & Equivalents Accounts Receivable Other Current Assets Total Current Assets Fixed Assets Total Non-Current Assets Total Assets LIABILITIES Short Term Debt Other Current Liabilities Total Current Liabilities Other Non-Current Liabilities Total Non-Current Liabilities Total Liabilities EQUITY Retained Earnings Current Earnings Other Equity Total Equity Total Liabilities & Equity $98,461 $95,408 $193,869 $176,794 $112,219 $245,333 $357,553 $166,566 $126,322 $241,132 $367,454 $161,451 $161.451 $528,905 $116,512 $240,571 $357,083 $159,031 $159,031 $516,114 $103,939 $238,495 $342,434 $159,031 $159,031 $501,465 $90,889 $226,575 $317,465 $158,531 $158,531 $475,995 $206,286 $268,076 $158,031 $158,031 $426,106 $53,898 $199,304 $253,202 $157,531 $157,531 $410,733 $49.536 $190.158 $239,694 $157,031 $157,031 $396,725 $49,536 $190,158 $239,694 $157,031 $157,031 $396,725 $176,794 $370.663 $166,566 $524,118 $24,545 $36.014 $37,201 $87,527 $63,756 $44,775 $13.569 $7,869 ($6.044) $71,169 $96,784 $129,248 $146,437 $158,749 $179,805 $219,807 $231,570 $242,200 ($116,754) ($125,754) ($134,254) ($143,254) ($150,754) ($158,254) ($173,254) ($180,754) ($188,254) ($21,040) $7,044 $32.196 $90,710 $71,752 $66,326 $60,123 $58,685 $47,903 $349,623 $531,162 $561,101 $606,824 $573,217 $542,322 $486,229 $469,418 $444,628 ($6.044) $242,200 ($188,254) $47,903 $444,628 Profit & Loss - YTD Jan 2021 Feb 2021 Mar 2021 Apr 2021 May 2021 Jun 2021 Jul 2021 Aug 2021 Sep 2021 Oct 2021 Nov 2021 Dec 2021 Total $38,466 $29,289 $54,261 $36,682 $40,149 $20,682 $29,348 $30,054 $19,781 $79,183 $18,456 $33,590 $37,890 $29,754 $34,341 $96,290 $54,853 $45,690 $28,091 $26,288 $6,592 $14,589 $29,485 $156,168 $99,335 $90,033 $91,918 ($1,724) ($1,897) ($1,043) ($2,191) $154,443 $97,439 $88,990 $89,727 $26,268 $39,832 $25,146 $10,594 $75,572 $0 $15,698 $76,529 $0 $76,529 $337,630 $366,778 - $167,752 - $872,160 ($6,854) - $865,305 $86,211 $117,211 $0 $0 $ $86,211 $117,211 $0 $79,183 $75,572 $3,119 $3,119 $3,119 $3,119 $3,119 $3,119 $20 $30 $30 $30 $3,119 $20 $150 $3,289 PROFIT & LOSS & Revenue Revenues from Legal Fees Practice Area 1 Practice Area 2 Practice Area 3 Total Revenues from Legal Fees Discounts/Refunds Given Total Revenue Expenses Occupancy Expenses Rent Janitorial Expenses Insurance Total Occupancy Expenses Employee Costs Owners/Partners / Associates Paralegal C-Suite Services Admin/Support Sales & Marketing Total Employee Costs Insurance General Liability & Other Owner Life Total Insurance Dues and Licenses Legal Research Industry Group $3,119 $30 $150 $3,299 $ $20 $150 $3,289 $3,119 $30 $150 $3,299 $28,067 $240 $1,350 $150 $3,289 $150 $3,299 $30 $150 $3,299 $150 $3,299 $150 $3,299 $29,657 $11,765 $11,765 $8,925 $9,043 $11,765 $7,625 $2,529 $7,250 $8,533 $11,765 $8,533 $9,417 $11,417 $11,765 $10,925 $8,737 $3,000 $1,656 $2,678 $11,765 $8,533 $9,417 $3,000 $1,752 $2,711 $3,000 $11,765 $11,765 $11,765 $6,585 $7,500 $9,685 $15,124 $9,508 $3,000 $3,000 $3,000 $1,735 $1,793 $1,765 $2,880 $2,624 $2,711 $36,314 $40,891 $36,250 $3,000 $1,574 $2,594 $3,000 $1,752 $105,885 $74,410 $84,876 $27,000 $15,820 $25,161 - $333,153 $3,000 $2,140 $3,711 $40,567 $1,652 $2,540 $2,711 $38,761 $36,901 $29,112 $37,179 $37,179 $402 $402 $402 $402 $579 $402 $579 $402 $579 $981 $402 $579 $579 $402 $579 $579 $579 $402 $579 $981 $3,615 $5,212 $8,827 $981 $981 $981 $981 $981 $981 $981 $325 $325 $382 $503 $360 $553 $360 $304 $360 $639 $325 $300 $425 $0 $425 $0 $3,287 $2,298 $0 $0 Jan 2021 Feb 2021 Mar 2021 Apr 2021 May 2021 Jun 2021 Jul 2021 Aug 2021 Sep 2021 Oct 2021 Nov 2021 Dec 2021 Total $177 $161 $1,836 $2,882 $98 $1,111 $205 $2,333 $3,536 $2,020 $86 $975 $1,686 $0 $1,050 $1,375 $0 $1,050 $1,375 $0 $ $1,050 $1,475 $50 $1,050 $1,525 $776 $12,474 $3,110 $1,872 $18,835 $2,268 $2,340 $1,585 $2,492 $871 $2,148 $435 $3,366 $120 $26,214 $6,747 $165 $3,183 $1,440 $307 $160 $5,089 $337 $3,653 $1,830 $389 $203 $6,075 $3,106 $150 $156 $0 $3,658 $150 $135 $100 $4,043 $185 $97 $3,645 $349 $151 $100 $2,833 $175 $4,437 SO $256 $0 $3,741 $2,265 $834 $36,059 $2,782 $3,412 $478 $549 $681 $857 $765 Licenses and Registrations Dues & subscriptions Others Total Dues and Licenses Operations Merchant Service Fees Bank Fees Working Meals Recruiting Total Operations Office Expenses Office Supplies Postage and Delivery Total Office Expenses Rainmaking Website Design Website Marketing - SEO Internet Advertising - PPC Print Advertising Gifts Total Rainmaking Automobile Expense Lease Payment Insurance Fuel $767 $195 $153 $631 $548 $93 $641 $169 $718 $569 $255 $824 $433 $196 $628 $55 $737 $153 $1,009 $153 $917 $5,647 $1,420 $7,068 $962 $180 $378 $466 $298 $0 $328 $0 $466 $3,450 $0 $0 $0 $466 $2,600 $1,235 $1,339 $1,220 $4,812 $2,267 $150 $0 $1,038 $2,561 $0 $3,748 $1,048 $2,405 $2,291 $1,372 $0 $3,842 $500 $2,000 $1,500 $600 $250 $4,850 $2,494 $3,231 $8,050 $15,532 $15,369 $750 $1,050 $405 $500 $5,871 $0 $2,880 $0 $4,478 $0 $0 $3,919 $386 $0 $4,687 $7,377 $4,160 $42,932 $1,582 $1,582 $1,582 $551 $1,582 $551 $64 $1,582 $551 $74 $551 $35 $1,582 $551 $69 $1,582 $551 $170 $1,582 $551 $551 $357 $88 $247 $1,582 $551 $209 $0 $50 $2,392 $14,240 $4,957 $1,313 $923 $339 $232 $140 $0 $0 $ SO $0 $255 $5 $2,458 $295 $6 $3 $25 $75 5 $5 $2,458 $75 $95 $2,475 $2,312 $2,508 $2,227 $2,378 $2,565 $21,771 Maintenance Parking & Tolls Total Automobile Expense Communications Telephone Internet Service Total Communications Professional Development Continuing Legal Education Business Skills Training Total Professional Development $204 $5,983 $ $6,187 $204 $1,178 $204 $1,795 $1,999 $204 $583 $787 $204 $586 $204 $586 $790 $204 $586 $790 $204 $586 $204 $586 $790 $1,838 $12,467 $14,305 $1,382 $790 $790 $556 $6,414 $6,970 $612 $4,376 $4,988 $336 $2,099 $2,435 $706 $2,752 $3,459 $366 $2,500 $2,866 $485 $2,500 $485 $5,500 $5,985 $485 $2,100 $2,585 $485 $2,100 $2,585 $4,516 $30,342 $2,985 $34,858 Jan 2021 Feb 2021 Mar 2021 Apr 2021 May 2021 Jun 2021 Jul 2021 Aug 2021 Sep 2021 Oct 2021 Nov 2021 Dec 2021 Total $1,103 $1,213 $667 $1,226 $1,107 $1,100 $1,100 $190 $10,017 $2,040 $355 $355 $190 $190 $1,401 $190 $61 $1,653 $48 $1,100 $190 $ $0 $1,290 $53 $30 $190 $50 $1,466 $190 $0 $1.297 $0 $0 $1,290 $243 $12,300 $1,506 $1,621 $888 $1,290 $926 $0 $450 $0 $1,530 $1,308 $81 $1,683 $1,439 $90 $1,944 $1,662 $0 $6,000 $791 $49 $500 $99 $906 $166 $0 $452 $257 $230 $125 $6,533 $13,289 $1,735 $104 $766 Computer I.T. Computer Software Case Management Software Computer Equipment Total Computer I.T. Taxes Occupation Taxes Travel Meals and Entertainment Professional Services Bookkeeper Consulting Others Total Professional Services Client Matter Expenses Total Expenses Operating Profit Interest Expenses Interest Expense Earnings Before Tax Net Income $1,250 $1,250 $1,250 $1,250 $269 $843 $1,250 $75 $1,250 $150 $0 $1,250 $309 $970 $2,529 $0 $234 $733 $2,217 $1,093 $82,363 $72,081 $1,250 $237 $744 $2,231 $1,388 $71,380 $18.347 $2,362 $1,202 $70,821 $26,618 $1,250 $130 $597 $1,976 $1,436 $65,620 $13,563 $125 $475 $1,850 $2,656 $63,970 $22,241 $661 $0 $1,250 $1,597 $75,852 $41,359 $270 $1,595 $ $2,597 $64,410 $12,119 $1,400 $3,465 $64,439 $11,133 $11,250 $1,529 $4,631 $17,410 $16,094 - $614,828 $ - $250,478 $55.973 $33,017 $1,003 $552 $356 $8,277 $912 $71,169 $71,169 $1,159 $17,189 $1,251 $12,312 $25,615 $1,186 $21,056 $21,056 $32,465 $32,465 $1,356 $40,002 $40,002 $242,200 $11,763 $11,763 $503 $10,630 $10,630 $25,615 $17,189 $12,312 $242,200