Income Statement
Actual Actual Actual Actual
Mar-21 Mar-22 Mar-23 Mar-24
Income
Revenue Stream 1 ₹ 345,000 ₹ 348,450 ₹ 351,935 ₹ 355,454
Revenue Stream 2 ₹ 125,000 ₹ 126,000 ₹ 127,008 ₹ 128,024
Revenue Stream 3 ₹ 57,200 ₹ 57,372 ₹ 57,544 ₹ 57,716
Revenue Stream 4 ₹ 5,300 ₹ 5,301 ₹ 5,302 ₹ 5,303
(-) Sales Returns -₹ 4,139 -₹ 2,686 -₹ 2,709 -₹ 2,732
Net Revenue ₹ 528,361 ₹ 534,437 ₹ 539,079 ₹ 543,765
Cost of Goods Sold
Variable Costs ₹ 157,389 ₹ 158,825 ₹ 160,280 ₹ 161,749
Fixed Costs ₹ 25,000 ₹ 25,000 ₹ 25,000 ₹ 25,000
Total Cost of Goods Sold ₹ 182,389 ₹ 183,825 ₹ 185,280 ₹ 186,749
Gross Profit ₹ 345,973 ₹ 350,612 ₹ 353,799 ₹ 357,016
Gross Margin % 65.48% 65.60% 65.63% 65.66%
Expenses
General & Administrative Expense
Insurance ₹ 1,000 ₹ 1,000 ₹ 1,000 ₹ 1,000
Rent or Lease ₹ 5,000 ₹ 5,000 ₹ 5,000 ₹ 5,000
Property Taxes ₹ 500 ₹ 500 ₹ 500 ₹ 500
Repairs and Maintenance ₹ 130 ₹ 130 ₹ 130 ₹ 130
Furniture & Fixtures ₹ 550 ₹ 550 ₹ 550 ₹ 550
Utilities ₹ 100 ₹ 100 ₹ 100 ₹ 100
Internet & Communications ₹ 100 ₹ 100 ₹ 100 ₹ 100
Infrastructure Services ₹ 250 ₹ 250 ₹ 250 ₹ 250
Software ₹ 120 ₹ 120 ₹ 120 ₹ 120
Bank Service Charges ₹ 75 ₹ 75 ₹ 75 ₹ 75
Business Licenses and Permits ₹ 150 ₹ 150 ₹ 150 ₹ 150
Conferences, Dues, and Subscriptions ₹ 600 ₹ 600 ₹ 600 ₹ 600
Supplies ₹ 1,000 ₹ 1,000 ₹ 1,000 ₹ 1,000
Gifts ₹ 500 ₹ 500 ₹ 500 ₹ 500
Printing , Postage and Delivery ₹ 230 ₹ 230 ₹ 230 ₹ 230
Miscellaneous ₹ 750 ₹ 750 ₹ 750 ₹ 750
Recruiting Expense ₹ 1,000 ₹ 1,000 ₹ 1,000 ₹ 1,000
Employee Travel and Meals ₹ 2,000 ₹ 2,000 ₹ 2,000 ₹ 2,000
Equipment Rental ₹ 1,100 ₹ 1,100 ₹ 1,100 ₹ 1,100
Other Tech Expense ₹ 400 ₹ 400 ₹ 400 ₹ 400
Professional Services ₹ 1,000 ₹ 1,000 ₹ 1,000 ₹ 1,000
Accounting Fees ₹ 1,000 ₹ 1,000 ₹ 1,000 ₹ 1,000
Legal Fees ₹ 2,500 ₹ 2,500 ₹ 2,500 ₹ 2,500
Consultant Fees ₹ 1,800 ₹ 1,800 ₹ 1,800 ₹ 1,800
Other Professional Services ₹ 540 ₹ 540 ₹ 540 ₹ 540
Marketing ₹ 3,000 ₹ 3,000 ₹ 3,000 ₹ 3,000
Public Relations ₹ 2,500 ₹ 2,500 ₹ 2,500 ₹ 2,500
Total G&A ₹ 27,895 ₹ 27,895 ₹ 27,895 ₹ 27,895
Salaries
Total Salaries ₹ 220,500 ₹ 220,500 ₹ 220,500 ₹ 220,500
Total Benefits ₹ 22,050 ₹ 22,050 ₹ 22,050 ₹ 22,050
Total Payroll Taxes ₹ 18,700 ₹ 18,700 ₹ 18,700 ₹ 18,700
Payroll Processing Fees ₹ 1,000 ₹ 1,000 ₹ 1,000 ₹ 1,000
Bonuses ₹ 10,000 ₹ 10,000 ₹ 10,000 ₹ 10,000
Commissions ₹ 16,000 ₹ 16,000 ₹ 16,000 ₹ 16,000
Total Salaries & Commissions ₹ 288,250 ₹ 288,250 ₹ 288,250 ₹ 288,250
Total Operating Expenses ₹ 316,145 ₹ 316,145 ₹ 316,145 ₹ 316,145
EBITA ₹ 29,828 ₹ 34,467 ₹ 37,654 ₹ 40,871
Other Income/Expenses
Interest Income ₹ 1,000 ₹ 1,000 ₹ 1,000 ₹ 1,000
Other Income ₹ 230 ₹ 230 ₹ 230 ₹ 230
Interest Expense ₹ 430 ₹ 430 ₹ 430 ₹ 430
Bad Debt Expense ₹ 350 ₹ 350 ₹ 350 ₹ 350
Depreciation Expense ₹ 120 ₹ 120 ₹ 120 ₹ 120
Amortization ₹ 100 ₹ 100 ₹ 100 ₹ 100
Total Interest, Depreciation & Amortizatio ₹ 2,230 ₹ 2,230 ₹ 2,230 ₹ 2,230
Net income (Loss) Before Income Taxes ₹ 27,598 ₹ 32,237 ₹ 35,424 ₹ 38,641
Taxes
Income Taxes ₹ 1,500 ₹ 1,500 ₹ 1,500 ₹ 1,500
Net income (Loss) ₹ 26,098 ₹ 30,737 ₹ 33,924 ₹ 37,141
Balance Sheet
Actuals Actuals Actuals Actuals Actuals
Beginning Bal #REF! #REF! #REF! #REF!
Current Assets
Cash & Cash Equivalents
Bank Balance $10,000 $36,256 $66,259 $98,581 $141,171
Total Bank Accounts $10,000 $36,256 $66,259 $98,581 $141,171
Inventory
Inventory $5,000 $4,000 $3,000 $5,000 $6,500
Total Inventory $5,000 $4,000 $3,000 $5,000 $6,500
Receivables
Accounts Receivable (A/R) $5,000 $6,000 $7,000 $8,600 $3,400
Total Receivables $5,000 $6,000 $7,000 $8,600 $3,400
Other Current Assets
Other Receivable $1,000 $1,000 $1,012 $1,025 $1,037
Prepaid Expenses $2,000 $2,000 $1,980 $1,960 $1,941
Prepaid Insurance $1,000 $1,500 $1,485 $1,470 $1,455
Unbilled Revenue $1,000 $1,250 $1,256 $1,263 $1,269
Other Current Assets $1,000 $1,100 $1,137 $1,176 $1,216
Total Other Current Assets $6,000 $6,850 $6,871 $6,894 $6,918
Total Current Assets $26,000 $53,106 $83,130 $119,075 $157,989
check $0 $0 $0 $0 $0
Noncurrent Assets
Depreciation & Amortization
Accumulated Depreciation $0 -$120 -$240 -$360 -$480
Accumulated Amortization $0 -$100 -$200 -$300 -$400
Other Noncurrent Assets
Patents & Goodwill $50,000 $50,000 $50,000 $50,000 $50,000
Furniture & Equipment $30,000 $30,000 $30,000 $30,000 $30,000
Computers & Software $100,000 $100,000 $100,000 $100,000 $100,000
Leasehold Improvements $25,000 $25,000 $25,000 $25,000 $25,000
Total Fixed Assets $205,000 $204,780 $204,560 $204,340 $204,120
Total Assets $231,000 $257,886 $287,690 $323,415 $362,109
check $0 $0 $0 $0 $0
Liabilities and Shareholders Equity
Current Liabilities
Accounts Payable
Accounts Payable (A/P) $2,000 $3,588 $2,691 $4,485 $5,831
Total Accounts Payable $2,000 $3,588 $2,691 $4,485 $5,831
Credit Cards
Credit Card 1 $1,000 $1,000 $1,000 $1,000 $1,000
Credit Card 2 $500 $500 $500 $500 $500
Total Credit Cards Payable $1,500 $1,500 $1,500 $1,500 $1,500
Notes/Short-Term Loans Payable
Loan 1 $10,000 $10,000 $10,000 $10,000 $10,000
Loan 2 $25,000 $25,000 $25,000 $25,000 $25,000
Total Notes Payable $35,000 $35,000 $35,000 $35,000 $35,000
Deferred Income/Advances from Customers
Deferred Income - current $5,000 $5,000 $5,000 $5,000 $5,000
Total Deferred Income $5,000 $5,000 $5,000 $5,000 $5,000
Other Current Liabilities
Accrued Expenses $1,000 $1,200 $1,044 $1,054 $1,265
Accrued Income Taxes $1,000 $1,000 $1,000 $1,000 $1,000
Other Current Liabilities $2,000 $1,000 $1,120 $1,117 $1,113
Total Other Current Liabilitie $4,000 $3,200 $3,164 $3,171 $3,379
Total Current Liabilities $47,500 $48,288 $47,355 $49,156 $50,709
check $0 $0 $0 $0 $0
Long-Term Liabilities
Long-term Debt $100,000 $100,000 $100,000 $100,000 $100,000
Deferred Income Taxes $3,000 $3,000 $3,000 $3,000 $3,000
Other Liabilities $5,000 $5,000 $5,000 $5,000 $5,000
Total Long-Term Liabilities $108,000 $108,000 $108,000 $108,000 $108,000
Total Liabilities $155,500 $156,288 $155,355 $157,156 $158,709
check $0 $0 $0 $0 $0
Shareholder's Equity
Paid-in Capital $10,000 $10,000 $10,000 $10,000 $10,000
Common Stock $25,500 $25,500 $25,500 $25,500 $25,500
Preferred Stock $10,000 $10,000 $10,000 $10,000 $10,000
Capital Raising Round 1 $10,000 $10,000 $10,000 $10,000 $10,000
Capital Raising Round 2 $10,000 $10,000 $10,000 $10,000 $10,000
Capital Raising Round 3 $10,000 $10,000 $10,000 $10,000 $10,000
Retained Earnings $0 $26,098 $56,835 $90,759 $127,900
Total Equity $75,500 $101,598 $132,335 $166,259 $203,400
Total Liabilities and Equity $231,000 $257,886 $287,690 $323,415 $362,109
check $0 $0 $0 $0 $0
Balance Sheet check
Assets $231,000 $257,886 $287,690 $323,415 $362,109
= Liabilities + Shareholder's Equity $231,000 $257,886 $287,690 $323,415 $362,109
check Balanced Balanced Balanced Balanced Balanced
Actuals Actuals Actuals Actuals Actuals Actuals Actuals Actuals
#REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509
Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509
$2,000 $6,200 $5,500 $6,700 $5,600 $6,200 $3,400 $6,200
$2,000 $6,200 $5,500 $6,700 $5,600 $6,200 $3,400 $6,200
$3,800 $7,000 $6,000 $5,500 $3,700 $7,000 $5,000 $4,000
$3,800 $7,000 $6,000 $5,500 $3,700 $7,000 $5,000 $4,000
$1,050 $1,063 $1,076 $1,089 $1,103 $1,116 $1,130 $1,144
$1,921 $1,902 $1,883 $1,864 $1,845 $1,827 $1,809 $1,790
$1,441 $1,426 $1,412 $1,398 $1,384 $1,370 $1,357 $1,343
$1,275 $1,282 $1,288 $1,294 $1,301 $1,307 $1,314 $1,320
$1,257 $1,300 $1,344 $1,390 $1,437 $1,486 $1,537 $1,589
$6,945 $6,973 $7,004 $7,036 $7,070 $7,107 $7,146 $7,187
Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509
Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509
Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509
Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509
$50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000
$30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000
$100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000
$25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000
Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509
Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509
Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509
$1,794 $5,561 $4,934 $6,010 $5,023 $5,561 $3,050 $5,561
$1,794 $5,561 $4,934 $6,010 $5,023 $5,561 $3,050 $5,561
$1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
$500 $500 $500 $500 $500 $500 $500 $500
$1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500
$10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000
$25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000
$35,000 $35,000 $35,000 $35,000 $35,000 $35,000 $35,000 $35,000
$5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
$5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
$1,101 $1,112 $1,334 $1,161 $1,172 $1,407 $1,224 $1,236
$1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
$1,110 $1,200 $1,196 $1,193 $1,340 $1,336 $1,332 $1,328
$3,211 $3,312 $3,531 $3,354 $3,512 $3,743 $3,556 $3,564
$46,505 $50,373 $49,964 $50,863 $50,036 $50,804 $48,106 $50,626
$0 $0 $0 $0 $0 $0 $0 $0
$100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000
$3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
$5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
$108,000 $108,000 $108,000 $108,000 $108,000 $108,000 $108,000 $108,000
$154,505 $158,373 $157,964 $158,863 $158,036 $158,804 $156,106 $158,626
$0 $0 $0 $0 $0 $0 $0 $0
$10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000
$25,500 $25,500 $25,500 $25,500 $25,500 $25,500 $25,500 $25,500
$10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000
$10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000
$10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000
$10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000
Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509
Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509
Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509
Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509
Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509
Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509
Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509
Statement of Cash Flows
Actual Actual Actual Actual
#REF! #REF! #REF! #REF!
Operations
Net Income $26,098 $30,737 $33,924 $37,141
Depreciation $120 $120 $120 $120
Amortization $100 $100 $100 $100
Change in Current Assets
Accounts Receivable -$1,000 -$1,000 -$1,600 $5,200
Inventory $1,000 $1,000 -$2,000 -$1,500
Other Current Assets -$850 -$21 -$23 -$25
Change in Current Liabilities
Accounts Payable $1,588 -$897 $1,794 $1,346
Deferred Revenues $0 $0 $0 $0
Current Liabilities -$800 -$36 $7 $208
Cash Flow from Operations $26,256 $30,003 $32,323 $42,590
Investing
Change in Fixed Assets $0 $0 $0 $0
Cash Flow from Investing $0 $0 $0 $0
Financing
Net Change in Credit Card/ Notes Payable $0 $0 $0 $0
Net borrowings (payments) on debt $0 $0 $0 $0
Cash Flow from Financing $0 $0 $0 $0
Beginning Cash Balance $10,000 $36,256 $66,259 $98,581
Change in Cash $26,256 $30,003 $32,323 $42,590
Ending Cash Balance $36,256 $66,259 $98,581 $141,171
Actual Actual Actual Actual Actual Actual Actual Actual
#REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509
Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509
Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509
-$400 -$3,200 $1,000 $500 $1,800 -$3,300 $2,000 $1,000
$4,500 -$4,200 $700 -$1,200 $1,100 -$600 $2,800 -$2,800
-$26 -$28 -$30 -$32 -$34 -$37 -$39 -$41
-$4,037 $3,767 -$628 $1,076 -$987 $538 -$2,512 $2,512
$0 $0 $0 $0 $0 $0 $0 $0
-$168 $101 $219 -$177 $159 $230 -$187 $8
Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$141,171 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509
Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509
Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509