ForecastLens
Demo Ltd

Balance Sheet

End-of-month positions · Apr-25 to Mar-27 · A$

Scenario
AUD $Apr 25May 25June 25July 25Aug 25Sept 25Oct 25Nov 25Dec 25Jan 26Feb 26Mar 26Apr 26May 26June 26July 26Aug 26Sept 26Oct 26Nov 26Dec 26Jan 27Feb 27Mar 27FY25 TotalFY26 Fcst
ActualActualActualActualActualActualActualActualActualActualActualActualForecastForecastForecastForecastForecastForecastForecastForecastForecastForecastForecastForecastActualForecast
ASSETS
Current Assets
Cash & Cash Equivalents$729,584$616,758$520,817$446,616$369,300$319,814$253,203$185,077$114,236$77,045$56,620$45,809$34,494$25,134$9,588$23,064$42,272$72,420$118,716$172,561$223,764$307,533$400,577$507,796$45,809$507,796
Accounts Receivable$150,000$162,000$175,000$187,000$200,000$214,000$229,000$242,000$255,000$265,000$279,000$292,000$303,000$315,000$328,000$342,000$357,000$373,000$390,000$407,000$425,000$444,000$464,000$484,000$292,000$484,000
Prepayments & Other$35,000$35,200$35,400$35,600$35,800$36,000$36,200$36,400$36,600$36,800$37,000$37,200$37,400$37,600$37,800$38,000$38,200$38,400$38,600$38,800$39,000$39,200$39,400$39,600$37,200$39,600
Total Current Assets$914,584$813,958$731,217$669,216$605,100$569,814$518,403$463,477$405,836$378,845$372,620$375,009$374,894$377,734$375,388$403,064$437,472$483,820$547,316$618,361$687,764$790,733$903,977$1,031,396$375,009$1,031,396
Non-Current Assets
Intangible Assets (net)$431,500$443,000$454,500$466,000$477,500$489,000$500,000$511,000$522,000$533,000$544,000$555,000$565,500$576,000$586,500$597,000$607,500$618,000$628,500$639,000$649,500$660,000$670,500$681,000$555,000$681,000
Property, Plant & Equipment (net)$83,800$82,600$96,400$95,200$94,000$92,800$91,600$90,400$104,200$103,000$101,800$100,600$99,400$98,200$112,000$110,800$109,600$108,400$107,200$106,000$119,800$118,600$117,400$116,200$100,600$116,200
Total Non-Current Assets$515,300$525,600$550,900$561,200$571,500$581,800$591,600$601,400$626,200$636,000$645,800$655,600$664,900$674,200$698,500$707,800$717,100$726,400$735,700$745,000$769,300$778,600$787,900$797,200$655,600$797,200
TOTAL ASSETS$1,429,884$1,339,558$1,282,117$1,230,416$1,176,600$1,151,614$1,110,003$1,064,877$1,032,036$1,014,845$1,018,420$1,030,609$1,039,794$1,051,934$1,073,888$1,110,864$1,154,572$1,210,220$1,283,016$1,363,361$1,457,064$1,569,333$1,691,877$1,828,596$1,030,609$1,828,596
LIABILITIES
Current Liabilities
Accounts Payable$60,750$60,750$60,750$60,750$60,750$60,750$67,350$67,350$67,350$67,350$67,350$67,350$69,000$69,000$69,000$69,000$69,000$69,000$69,000$69,000$69,000$69,000$69,000$69,000$67,350$69,000
Deferred Revenue$90,000$97,200$105,000$112,200$120,000$128,400$137,400$145,200$153,000$159,000$167,400$175,200$181,800$189,000$196,800$205,200$214,200$223,800$234,000$244,200$255,000$266,400$278,400$290,400$175,200$290,400
Accruals & Other$28,000$28,000$28,000$28,000$28,000$28,000$28,000$28,000$28,000$28,000$28,000$28,000$28,000$28,000$28,000$28,000$28,000$28,000$28,000$28,000$28,000$28,000$28,000$28,000$28,000$28,000
Total Current Liabilities$178,750$185,950$193,750$200,950$208,750$217,150$232,750$240,550$248,350$254,350$262,750$270,550$278,800$286,000$293,800$302,200$311,200$320,800$331,000$341,200$352,000$363,400$375,400$387,400$270,550$387,400
Non-Current Liabilities
Bank Loan$491,667$483,334$475,001$466,668$458,335$450,002$441,669$433,336$425,003$416,670$408,337$400,004$391,671$383,338$375,005$366,672$358,339$350,006$341,673$333,340$325,007$316,674$308,341$300,008$400,004$300,008
Total Liabilities$670,417$669,284$668,751$667,618$667,085$667,152$674,419$673,886$673,353$671,020$671,087$670,554$670,471$669,338$668,805$668,872$669,539$670,806$672,673$674,540$677,007$680,074$683,741$687,408$670,554$687,408
EQUITY
Share Capital$500,000$500,000$500,000$500,000$500,000$500,000$500,000$500,000$500,000$500,000$500,000$500,000$500,000$500,000$500,000$500,000$500,000$500,000$500,000$500,000$500,000$500,000$500,000$500,000$500,000$500,000
Retained Earnings / (Deficit)$259,467$170,274$113,366$62,798$9,515($15,538)($64,416)($109,009)($141,317)($156,175)($152,667)($139,945)($130,677)($117,404)($94,917)($58,008)($14,967)$39,414$110,343$188,821$280,057$389,259$508,136$641,188($139,945)$641,188
Total Equity$759,467$670,274$613,366$562,798$509,515$484,462$435,584$390,991$358,683$343,825$347,333$360,055$369,323$382,596$405,083$441,992$485,033$539,414$610,343$688,821$780,057$889,259$1,008,136$1,141,188$360,055$1,141,188
TOTAL LIABILITIES & EQUITY$1,429,884$1,339,558$1,282,117$1,230,416$1,176,600$1,151,614$1,110,003$1,064,877$1,032,036$1,014,845$1,018,420$1,030,609$1,039,794$1,051,934$1,073,888$1,110,864$1,154,572$1,210,220$1,283,016$1,363,361$1,457,064$1,569,333$1,691,877$1,828,596$1,030,609$1,828,596
Balance check (= 0)——————————————————————————