Actual months. When a month closes, enter your actual figures and see them next to the projection.
PR Owner Pro Pack
Will your money cover this month? See it before it happens.
A 12-month Excel model and 6 more tools. You enter your numbers and see your business's cash at the end of each month.
$99one-time payment
Buy the Pack
$99, one-time payment. No renewal. No refunds after delivery. Full terms
Sample images with fictitious data. Appearance in your program may vary.
Want to see it? View a sample (Spanish PDF, fictitious data)
The core
The 12-month model
12-Month Financial Projections (Estados Proyectados del Negocio · 12 meses). You write your assumptions: the sales you expect each month, your expenses and what you owe. The model shows how your profit, your cash and your debts would move over the next 12 months.
- Cash at the end of each month
- The minimum cash you set
- The lowest month
Example: fictitious data.
- Which months make money and which don't.
- A summary of the year, with a few lines in plain language about what your numbers say.
Does your business have a slow season? You write sales month by month. Put less in the slow months and see whether your cash holds until sales pick up again.
For internal use; it is not a prediction. Results depend on your assumptions.
Seasonal curve. Spread a yearly sales goal based on how you sold in past years. It is not a forecast.
Months of cash. If cash goes down, see roughly how many months it would last at that pace.
Examples
How it works for a business like yours
Barbershop or salon: does what comes in during the good months cover rent and payroll in the slow ones?
Food truck: which months leave extra cash, and which ones need a cushion?
Colmado (corner store): which month is your cash at its lowest?
Contractor: does your cash hold while you wait to be paid for the job?
Examples to illustrate use. Results depend on the assumptions you enter.
Comparison
Free vs. Pro Pack
| What's included | Free templates | Pro Pack |
|---|---|---|
| 12-month model: cash, profit and debts month by month | No | Yes |
| Actual and projected months | No | Yes |
| Seasonal curve | No | Yes |
| Months of cash | No | Yes |
| Cash flow, break-even, IVU, budget and loan | Yes | Yes, Pro version |
| Three-year summary | No | Yes |
| Blank and example file | Yes | Yes |
| How you get it | By email, when you sign up | .zip file, digital delivery |
| Price | Free | $99, one-time payment |
$99one-time payment
Buy the Pack
Also included
Other tools in the Pack
Each one comes with a blank file and an example file with fictitious data. It also includes the Guía del Dueño, the «Primeros 30 minutos y Cierre del mes» sheet and an index.
C01
13-Week Cash Flow Forecast (Pro)
Week by week, and the first week your cash falls below your minimum.
C02
Break-Even & Margin Calculator (Pro)
How much you have to sell to cover your costs, and what each service leaves.
C03
Monthly Sales Tax (IVU) Organizer (Pro)
Estimated, collected and remitted IVU, month by month. It does not file or connect to SURI.
C04
Income Statement (P&L) & Budget (Pro)
Your budget against what actually happened, and which expenses went over.
C05
Loan Readiness Checklist (Pro)
The documents a bank or cooperative usually asks for, and which ones you still need. It does not predict approval.
C06
Resumen Financiero Pro (financial summary)
Three years of numbers in one summary, for when you have that track record. It is not a valuation.
21 files: 14 spreadsheets, 2 Word documents and 5 PDFs.
Sample images with fictitious data. Appearance in your program may vary.
How it works
From purchase to your computer
- Buy the Pack.$99, one-time payment. No renewal.Payment on Kit
- Digital delivery.A .zip file with 21 files.Kit
- Work at your own pace, in Excel.With the Guía del Dueño and the «Primeros 30 minutos y Cierre del mes» sheet.On your computer
It's for you if…
- You have a business in Puerto Rico and want to know ahead of time whether your cash will stretch.
- Your sales go up and down during the year.
- You prefer to work at your own pace, in Excel, with instructions in Spanish.
It's not for you if…
- You are looking for someone to keep your books.
- You need tax, legal, or financial advice, or want to use the files to provide services to others.
- You want a program that connects to your bank, to SURI, or to your accounting system.
Questions
There are no refunds. How do I know if it's right for me before buying?
See the full example of a fictitious barbershop (PDF) and try the 5 free templates. If a file doesn't work, AXIS fixes it at no cost for 12 months from purchase (does not include custom changes, advice or sessions).
What do you receive?
A .zip file with 21 files (14 spreadsheets, 2 Word documents and 5 PDFs), version 1.0.5. Digital delivery.
Do you own more than one business?
You can use the files for each one. Not for providing services to clients or for resale.
Which tool should you start with?
With the 12-month model: it works with the assumptions you enter. The Resumen Financiero Pro (financial summary) summarizes three years of numbers; use it once you have that history.
Does it work in Google Sheets?
The tools are built for Excel 2016 or later. You can also open them in Google Sheets. AXIS uploaded the 14 files of version 1.0.5 to Google Sheets and checked the following:
- All formulas calculate without errors, including the example files.
- Charts are kept.
- Dropdown lists and warning colors are kept.
Some functions and formatting may behave differently. For example, cell protection only applies in Excel; in Google Sheets, type only in the input cells. It has also not been tested on phones. For best results, use Excel on your computer.
Do I need to know a lot of Excel?
You don't need to be an expert. You type in the input cells and the model does the calculations. The Pack includes the Guía del Dueño and the «Primeros 30 minutos y Cierre del mes» sheet to get started. If you have a question about the files, write to AXIS on WhatsApp or at info@axisadvisorypr.com.
My business is new and has no history. Will it work for me?
Yes. The 12-month model works with the sales and expenses you expect; you don't need years of numbers. The Resumen Financiero Pro (financial summary) is for when you have three years of history.
Who is behind AXIS?
AXIS Independent Advisory is an independent advisory practice in Puerto Rico that builds Excel tools for businesses. You can write to AXIS on WhatsApp at (787) 830-6462 or at info@axisadvisorypr.com.
$99one-time payment
Terms
What you receive: a .zip file with 21 files (14 spreadsheets, 2 Word documents and 5 PDFs), version 1.0.5. Digital delivery.
$99, one-time payment. No renewal.
Free fixes for files that don't work, for 12 months from purchase (does not include custom changes, advice or sessions).
12 months of updates.
License for your business, or each business you own. Not for providing services to clients or for resale.
Do you own more than one business? You can use the files for each one.
No refunds after delivery.
Seller: AXIS Independent Advisory.
Compatibility: Built for Excel 2016 or later. They can be opened in Google Sheets; some functions and formatting may behave differently. No macros.
Notice: an educational and organizing tool. It does not constitute tax, legal, financial, or investment advice, or a business valuation or appraisal. Projections depend on your assumptions and are not a prediction. It does not indicate whether a loan will be approved.
These tools are financial models. Results depend on the assumptions you enter, such as rates, taxes and other important assumptions for your business. You are responsible for those assumptions; if you are unsure, consult your accountant or CPA. AXIS Independent Advisory is not responsible for the models' assumptions.
Microsoft and Excel are trademarks of Microsoft Corporation. AXIS Independent Advisory is not affiliated with Microsoft. Google Sheets is a trademark of Google LLC.