Jeremy Counter

Toolkit · $39 · Digital download

Run the numbers on an Alaska rental before you make an offer

A spreadsheet that turns one property’s numbers into cash flow, cap rate, cash-on-cash return, DSCR, a 1% rule check, break-even rent and a sensitivity table, with separate lines for the costs Alaska owners can’t skip: heat, snow removal and capital repairs.

$39

Buy now: $39

Secure checkout by Stripe. After you pay, you go straight to your download page. Digital download. Sold by Aurora Information Services LLC, Anchorage, Alaska.

What it calculates

Monthly and annual cash flowWhat’s left after operating expenses and the loan payment (before income taxes)
Cap rateNet operating income ÷ purchase price
Cash-on-cash returnAnnual cash flow ÷ the cash you put in (down payment, closing costs, upfront repairs)
DSCRNet operating income ÷ annual loan payments, checked against a target you set
1% rule checkMonthly rent as a share of price. A quick screen, not a decision rule.
Break-even rentThe monthly rent at which cash flow is $0, and how far your rent is above or below it
Sensitivity tableMonthly cash flow across 5 rent levels × 5 interest rates, plus a vacancy row from 0% to 15%
Results tab of the analyzer, shown with the built-in example assumptions
The Results tab with the built-in example assumptions. Those are illustration numbers, not market data, and the example deal loses money. That’s on purpose: the tool is meant to tell you “no” when the numbers say no.

Built for Alaska line items

How it works

  1. Open it in Excel, Google Sheets or LibreOffice. No macros, no add-ins.
  2. Replace every yellow cell on the Inputs tab with numbers for your property. Each input has a note on where to find the real number.
  3. Read the Results and Sensitivity tabs. A 5-page PDF guide explains what each result means and how to read it.

The honest part

Not financial, legal, tax or investment advice. This is a calculator, not a recommendation to buy any property. Real estate investing carries risk, including loss of capital. Talk to a licensed lender, CPA or attorney before you make a decision.

Who it’s for

People sizing up a single-family rental or small multi-unit, such as a duplex or fourplex, in Anchorage, Mat-Su or elsewhere in Alaska. It pairs with my book Alaska Real Estate Investing, and you don’t need the book to use it.

Questions

Does it work in Google Sheets?

Yes. Upload the .xlsx to Google Drive and open it with Google Sheets. It also works in Excel and LibreOffice.

Can I use it for a duplex or fourplex?

Yes. Enter the total monthly rent for all units and the owner-paid costs for the building.

Does it tell me whether to buy?

No. It shows the math on the numbers you enter. The decision is yours, ideally with a lender and CPA.

Where do the example numbers come from?

They’re made-up illustration values chosen to show how the sheet works. They aren’t averages or market data.

What if it’s not for me?

All sales final on digital downloads. If a file doesn’t work, email jeremy@jeremycounter.com within 14 days and I’ll fix it or refund you.

$39

Buy now: $39

Secure checkout by Stripe. After you pay, you go straight to your download page. Digital download. Sold by Aurora Information Services LLC, Anchorage, Alaska.

Want the AI Prompt & SOP Pack too? Get both for $59 →