Astro Hospitality

Astro Hospitality - Business Financial Forecast

FY2027 (April 2026 - March 2027) | Interactive Dashboard
Executive Summary
Assumptions
P&L Forecast
Balance Sheet
Cash Flow
Alerts
Scenario Planner

Key Performance Indicators

Breakeven Calculator

Trading Division Split

Based on budget allocation. Astro ~78%, Berica ~22% of revenue.

Working Capital

32
35
150

Target Stock Level by Month ($)

Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Jan
Feb
Mar
Default: COGS × stock_days / 30 (auto-populated). Edit any month to override; use Reset to Formula to clear overrides. Reduce values to model a stock drawdown.

OD Facility Limit by Month ($)

Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Jan
Feb
Mar
Set the overdraft facility limit per month. Alerts trigger when cash exceeds this limit.

Capital Expenditure

Direct: $4,456/mo | Overhead: $13,367/mo

Financing

7%

Opening Balances (1 April 2026)

Opening Balances (cont.)

Tax & Adjustments

28%
0%
46.0%
6.2%

Profitability Ratios

Balance Sheet Ratios

Cash Flow Metrics

Add Adjustment

Add adjustments above to see the impact on Revenue, EBITDA, NPBT, NPAT, and Cash.