How to Account for a Gain / Loss on Sale in Cash Flow Statement with the Indirect Method

When using the indirect method for preparing a cash flow statement, the gain on the sale of an asset is adjusted because the cash flow statement starts with net income, which includes the gain. However, the gain does not affect cash directly; it merely reflects the result of an asset being sold above its book value. Here's how to adjust for it:

Dynamic Loan Amortization Schedule Template

SmartHelping / Lending / Excel

Dynamic Loan Amortization Schedule

Add flexible debt financing to almost any financial model with two self-contained Excel schedules: one for a standard loan and one for a line of credit. Model interest-only periods, amortizing payments, extra principal, early payoff, changing rates, and LOC conversion without rebuilding the debt logic from scratch.

2 self-contained tabs Loan and line of credit Interest-only and amortizing periods Plug-and-play Excel logic

$45 One-time purchase / Excel download

Add Loan Amortization Template to Cart

Immediate download after purchase. By purchasing, you agree to the Terms of Service.

Watch the walkthrough Explore the features Review the loan tab Review the LOC tab How to use it Included in bundles

See the model in action

See how the loan and line-of-credit schedules adapt.

Watch the walkthrough, then open the screenshots to review the inputs, interest-only logic, amortizing repayment schedules, extra principal options, and LOC conversion mechanics.

Open the model screenshots

Review both self-contained tabs and the input-driven payment schedules before purchasing.

What the model includes

Flexible debt schedules built to drop into another model.

Each tab is completely self-contained, so you can copy it into another workbook and map the relevant proceeds, interest, principal, and ending-balance outputs without broken references.

01 / SELF-CONTAINED TABS

Copy either schedule without reference errors

The Loan and Line of Credit tabs operate independently, making each one easy to paste into a new or existing financial model.

02 / INTEREST-ONLY PERIOD

Set the exact number of interest-only months

Use zero months when no interest-only period is needed, or define a separate period before principal amortization begins.

03 / AMORTIZATION START

Control when regular repayments begin

Choose the month number when amortizing principal and interest payments start after funding or an interest-only phase.

04 / TERM VS AMORTIZATION

Model a loan term that differs from its amortization period

Separate contractual maturity from the amortization horizon to support balloon balances and other common financing structures.

05 / EXTRA PRINCIPAL

Add discretionary principal repayments

Enter extra principal payments and choose whether they reduce future scheduled payments or leave those payments unchanged.

06 / EARLY PAYOFF

Repay the remaining balance on a selected date

Turn on early repayment and use a manually defined end date to clear the outstanding loan balance.

07 / DYNAMIC PAYMENT STOP

Align debt payments with an exit month

Stop scheduled payments dynamically when the surrounding investment or operating model reaches its exit period.

08 / SEPARATE RATES

Use different interest-only and amortizing rates

Define separate rates for each phase and adjust them by month when a financing structure requires changing assumptions.

The Loan tab

Model one funded loan from proceeds through payoff.

The standard Loan tab handles a single draw, an optional interest-only phase, and a regular amortizing schedule with flexible repayment behavior.

Funding

Enter the loan proceeds and the month funding occurs, then reference the proceeds column wherever the broader model records debt financing.

Interest-only phase

Define the number of interest-only months and its rate, then choose whether the loan ends after that period or continues into amortization.

Amortizing phase

Set the repayment start month, amortization period, loan term, and amortizing rate to calculate principal and interest over time.

Repayment controls

Add extra principal, decide whether it recasts future payments, trigger early payoff, or stop payments at the exit month used elsewhere in the model.

Model integration

The schedule separates proceeds, interest, principal repayment, and balance outputs so they can be mapped into financial statements and summaries.

The Line of Credit tab

Model monthly draws, interest-only payments, and an optional term conversion.

The separate LOC schedule keeps the flexible repayment features of the Loan tab while allowing financing proceeds to be drawn manually over time.

MONTHLY DRAWS

Enter line-of-credit funding as it occurs

Define the amount borrowed each month instead of assuming one up-front loan funding event.

OUTSTANDING BALANCE

Calculate interest on net borrowings

Interest follows the amount drawn over time less principal already repaid, keeping financing cost tied to the outstanding LOC balance.

TERM CONVERSION

Switch the LOC into amortization on a selected month

Select the conversion date and begin principal-and-interest payments using the balance outstanding in the month of the switch.

BALLOON PAYOFF

Repay the balance if the LOC does not convert

If the line remains interest-only, the remaining principal can be repaid at the end of the defined interest-only period.

How to use it

Add the right debt schedule to your model in four steps.

1. 01

   Choose the Loan or LOC tab

   Use the single-funding Loan schedule or the manually drawn Line of Credit schedule based on the financing structure you need.

2. 02

   Set funding, rates, and timing

   Enter the debt amount or monthly draws, interest-only duration, amortization start, term, amortization period, and applicable rates.

3. 03

   Configure repayment behavior

   Choose whether the debt amortizes, ends after interest-only payments, converts from a LOC, accepts extra principal, or repays early.

4. 04

   Copy and map the schedule

   Paste the self-contained tab into the destination workbook and link its proceeds, interest, principal payments, and balances to the relevant statements.

Who gets value from it

Built for anyone adding flexible debt to a forecast.

Financial modelers

Reuse a dependable loan or LOC schedule instead of rebuilding debt formulas for every new model.

Business owners and finance teams

Compare financing structures, payoff timing, extra principal strategies, and interest expense over time.

Real-estate and acquisition analysts

Align loan proceeds and payments with closing, hold periods, refinancings, and exit months.

Lenders, advisors, and consultants

Build flexible repayment schedules for client forecasts, underwriting, and scenario analysis.

Also available in these bundles

Need a broader spreadsheet library?

The Dynamic Loan Amortization Schedule is also included in the Lending Models bundle and the Accounting Templates bundle.

Lending Models

Use a broader collection of loan, debt, credit, securitization, and lending-business financial models.

View Lending Models

Accounting Templates

Build out practical accounting, cash management, cost analysis, and financial reporting tools.

View Accounting Templates

Related loan repayment templates

Extend the debt, lending, and repayment analysis.

Use these complementary SmartHelping models for loan businesses, securitization, seller financing, interest-rate analysis, repayment planning, and capital structure decisions.

Loan Brokerage

Forecast deal volume, fees, staffing, operating costs, and economics for a loan brokerage business.

Explore the brokerage model

Loan Securitization Facilitator

Model a platform that organizes loan pools and facilitates securitization transactions.

Explore the facilitator model

Discount Bond Model

Calculate bond pricing, discount accretion, interest expense, and cash repayment over time.

Explore the bond model

Buy Now, Pay Later Firm

Forecast customer originations, merchant fees, funding, repayments, losses, and operating performance.

Explore the BNPL model

Loan Securitization

Model pooled-loan cash flows, capital-stack distributions, credit losses, and investor returns.

Explore the securitization model

Seller Financing Amortization

Build the repayment schedule and compare the economics of seller-financed transactions.

Explore seller financing

Interest Rate Swap

Evaluate fixed-versus-floating rate exposure and the cash-flow impact of an interest-rate swap.

Explore the swap model

Mortgage Savings Calculator

Measure interest savings and payoff acceleration from additional mortgage payments.

Explore the mortgage calculator

Pay Off Loans or Invest

Compare the return from investing available cash with the savings from reducing debt.

Explore the decision model

Multiple Loan Repayment Planner

Prioritize payments across multiple debts and compare payoff strategies over time.

Explore the repayment planner

Own vs Rent Calculator

Compare the long-term financial implications of purchasing a home versus renting.

Explore the own-vs-rent model

General Lending Business Startup Model

Forecast loan originations, interest income, losses, funding, capital, and lender profitability.

Explore the lending model

Loan Portfolio Analysis

Analyze portfolio balances, yields, repayments, defaults, and performance across a loan book.

Explore the portfolio model

Lending-as-a-Service Platform Startup

Model the unit economics and operating forecast for a lending infrastructure platform.

Explore the L-aa-S model

Cap Table with Convertible Note

Track founder and investor ownership, financing rounds, and convertible-note dilution.

Explore the cap table

Questions before you buy

A few useful details.

What is included in the download?

The Excel workbook contains two independent, self-contained tabs: one for a standard loan and one for a line of credit.

Can I copy a tab into another financial model?

Yes. Each tab is designed to be copied as a complete unit without creating external reference errors, then mapped into the destination model.

Can the model handle an interest-only period?

Yes. Set the number of interest-only months, including zero, and use an interest-only rate that can differ from the later amortizing rate.

Does it support extra principal and early payoff?

Yes. You can add extra principal payments, choose whether they reduce future scheduled payments, and repay the remaining balance on a selected end date.

Can a line of credit convert to a term loan?

Yes. Define the month of conversion and begin principal-and-interest payments based on the balance outstanding at that time.

Is it included in any bundles?

Yes. It is included in the Lending Models bundle and the Accounting Templates bundle.

Stop rebuilding debt schedules

Add flexible loan and LOC logic to your next financial model.

Use two self-contained Excel tabs for interest-only periods, amortization, extra principal, early payoff, exit timing, and LOC conversion. One-time purchase for $45.

Get the Loan Amortization Template

Examples of Concessions in Real Estate Modeling

 In real estate modeling, "concessions" refer to incentives or discounts offered by property owners or landlords to tenants or buyers to make a property more attractive. These can take various forms, including:

Check out these real estate models and specifically this multi-family underwriting model may be of interest.

1. Rent Abatements: Temporary reductions or waivers of rent, often used to entice tenants to sign a lease.

2. Free Rent Periods: Offering a certain period of free rent at the beginning of a lease term.

3. Tenant Improvements (TIs): The landlord may pay for or contribute to the cost of customizing the leased space to the tenant's specifications.

4. Discounts on Purchase Price: Reductions on the sale price of a property.

5. Cash Incentives: Direct payments to tenants or buyers, sometimes referred to as "cash-back" deals.

6. Reduced Security Deposits: Lowering the amount required for a security deposit.

Generally all concessions will be defined by a single row in real estate models and based on a % of potential rental income. Sometimes, these reductions to income are just lumped into vacancy.

You may also be interested in what economic vacancy is in RE models.

Concessions are used to attract tenants or buyers, especially in competitive markets or when there is a need to quickly lease or sell a property. In financial modeling, these concessions are accounted for in cash flow projections, impacting the overall valuation and financial performance of the property.

Article found in Real Estate.

Financial Statement Example for Non-Profit

 Creating a comprehensive set of financial statements for a non-profit organization involves several key line items. Here’s an outline for each of the three primary financial statements: the Statement of Financial Position, the Statement of Activities, and the Statement of Cash Flows.

Is There Opportunity in the Wind Farm Business?

 There is significant opportunity in the wind farm business due to the increasing global emphasis on renewable energy sources and the decline in the cost of wind technology. Here are some key factors and locations to consider:

Exit Readiness Model - How Ready Is Your Business to Sell?

SmartHelping / Business Valuation / Excel

Exit Readiness Model

Measure how prepared a business is to sell with a structured, industry-neutral scorecard covering financial health, market position, operations, governance, compliance, strategy, and risk. Use weighted scores and clear grades to identify weaknesses, prioritize improvements, and understand whether the business is more likely to attract a higher or lower valuation.

7 main categories 24 subcategories Weighted 1–10 scoring Printable summary

$65 One-time purchase / Excel download

Add Exit Readiness Model to Cart

Immediate download after purchase. By purchasing, you agree to the Terms of Service.

Watch the walkthrough Explore the features Review the framework Understand the grades How to use it Included in bundles

See the model in action

See how the scorecard turns business quality into an exit-readiness grade.

Watch the walkthrough, then open the screenshots to review the category inputs, adjustable weights, conditional formatting, grade calculations, and print-ready summary.

Open the model screenshots

Review the editable scorecard, category grades, color-coded results, and printable summary before purchasing.

What the model includes

A structured way to measure how sellable a business is.

Score the factors buyers and investors care about, adjust the importance of each factor, and convert the assessment into category grades and one overall readiness result.

01 / 7 MAIN CATEGORIES

Evaluate the complete business

Review seven major dimensions of exit readiness rather than relying only on earnings or a valuation multiple.

02 / 24 SUBCATEGORIES

Break broad issues into actionable factors

Use 24 more detailed areas to identify the specific strengths and weaknesses driving each major category.

03 / YELLOW INPUT CELLS

Know exactly where to enter assumptions

Update the highlighted yellow cells to complete the assessment while leaving the underlying scoring logic intact.

04 / ADJUSTABLE WEIGHTS

Reflect the priorities of the business or client

Assign weights to both subcategories and main categories so the final grade reflects what matters most.

05 / 1–10 SCORING

Turn qualitative judgment into comparable results

Grade each area on a consistent 1–10 scale and calculate weighted results for the individual categories.

06 / LETTER GRADES

Summarize readiness from A through F

Translate numeric results into intuitive letter grades for every main category and the business overall.

07 / COLOR-CODED RESULTS

Spot strong and weak areas immediately

Green, yellow, and red conditional formatting makes favorable results, caution areas, and problems easy to scan.

08 / PRINT-READY SUMMARY

Present the assessment on a standard page

The summary is formatted for 8.5 × 11 printing, making it practical for management reviews and client discussions.

The seven-category framework

Evaluate the areas that shape buyer confidence and valuation.

The industry-neutral framework covers the operating, financial, organizational, and risk factors that influence whether a business is ready to sell.

Financial health

Assess the quality, stability, visibility, and documentation of the company's financial performance.

Market position

Review competitive strength, customer concentration, differentiation, and the durability of market demand.

Operational efficiency

Examine process quality, systems, documentation, consistency, and the ability to operate without unnecessary friction.

Management and governance

Consider leadership depth, owner dependence, accountability, decision-making, and organizational continuity.

Legal and regulatory compliance

Identify documentation gaps, unresolved obligations, compliance risks, and other issues that may concern a buyer.

Strategic vision

Evaluate the clarity of future plans, growth opportunities, competitive priorities, and alignment with exit objectives.

Risk management

Measure how effectively the business identifies, controls, and prepares for operational, financial, legal, and market risks.

How the grades are interpreted

Move from a 1–10 score to a clear readiness level.

Higher scores indicate a business that is more attractive to buyers or investors and generally requires fewer improvements before an exit.

A / 9.0–10.0

Excellent readiness

The company is highly attractive to potential buyers or investors, is well prepared for an exit, and needs minimal improvement.

B / 7.0–8.9

Good readiness

The business is generally attractive and performs well across most metrics, with a few areas that may benefit from improvement.

C / 5.0–6.9

Moderate readiness

The company has balanced strengths and weaknesses and likely requires several improvements before a successful exit.

D / 3.0–4.9

Poor readiness

Significant work is needed across multiple areas to strengthen the business and improve its attractiveness to buyers.

F / 0.0–2.9

Very poor readiness

The business is not currently in a suitable state for exit and may require a comprehensive turnaround to address fundamental issues.

How to use it

Turn the scorecard into an improvement plan.

1. 01

   Complete the highlighted inputs

   Use the yellow cells to score the business across the 24 subcategories using evidence and objective metrics wherever possible.

2. 02

   Review or customize the weights

   Keep the researched default weights or adjust them to reflect the industry, client, strategic goals, and intended exit.

3. 03

   Study the category and overall grades

   Use the weighted scores and color coding to see where the business is strong and which issues most reduce exit readiness.

4. 04

   Create actions and repeat the assessment

   Prioritize the highest-impact weaknesses, document the rationale, gather stakeholder feedback, and rerun the scorecard quarterly or annually.

Who gets value from it

Useful before selling, buying, advising, or improving a business.

Business owners preparing to sell

Identify the issues most likely to reduce buyer confidence or valuation before entering a sale process.

Acquisition buyers

Use the same framework to assess the quality and transferability of a business being considered for purchase.

Consultants and exit advisors

Run a consistent client assessment, customize the weights, and present a clear summary of priorities.

Management and finance teams

Track improvement over time and align operating initiatives with the company's long-term exit objectives.

Also available in these bundles

Need a broader spreadsheet library?

The Exit Readiness Model is also included in the Business Valuation bundle and the Super Smart Bundle.

Business Valuation

Use a broader collection of valuation, DCF, LBO, return, sensitivity, and exit-analysis spreadsheets.

View Business Valuation Models

Super Smart Bundle

Get the complete SmartHelping collection for forecasting, valuation, accounting, financing, real estate, and more.

View Super Smart Bundle

More valuation spreadsheet templates

Extend the valuation, return, and transaction analysis.

Use these complementary SmartHelping models to evaluate business value, leverage, discount rates, return thresholds, downside cases, and investor distributions.

Business Turnaround Deal Template

Model the operational reset, financing, recovery plan, and potential returns of a distressed business.

Explore the turnaround model

TAM Sizing Model

Estimate total, serviceable, and obtainable market opportunity using transparent operating assumptions.

Explore the TAM model

LBO Model with T12

Use trailing operating results, leverage, debt paydown, and exit assumptions to assess acquisition returns.

Explore the T12 LBO model

Leveraged Buyout Model - Advanced

Analyze a detailed leveraged acquisition with financing layers, cash flow, debt reduction, and exit value.

Explore the advanced LBO

Small Business Valuation Sensitivity

Compare business value across changing operating performance and valuation assumptions.

Explore valuation sensitivity

Business Valuation Using EBITDA Multiple

Estimate enterprise and equity value using EBITDA and selected transaction multiples.

Explore the EBITDA valuation

WACC Calculator

Estimate the blended cost of debt and equity for valuation and investment analysis.

Explore the WACC calculator

DCF Analysis - Monthly

Value an investment using monthly cash flows, discounting, terminal value, and present value.

Explore the monthly DCF

DCF Analysis with IRR and NPV Sensitivity

Test investment returns and present value across changing operating and exit assumptions.

Explore the DCF sensitivity model

Gordon Growth Model

Estimate terminal value using a perpetual growth rate and required return.

Explore the Gordon Growth model

Interest Rate Swap

Evaluate fixed-versus-floating rate exposure and the cash-flow effect of a swap.

Explore the swap model

IRR Targeting Template

Back into the pricing, cash flow, or exit assumptions needed to reach a target return.

Explore the IRR target model

Preferred Return Waterfall

Allocate cash flow across investor tiers using preferred returns and promote structures.

Explore the preferred return model

IRR Hurdle Waterfall

Model return hurdles, GP catch-up mechanics, and tiered cash-flow distributions.

Explore the IRR waterfall

Questions before you buy

A few useful details.

Can this be used for any industry?

Yes. The framework is intentionally industry-neutral and can be customized by changing category weights, subcategory weights, and scoring thresholds.

Can a buyer use it as well as a seller?

Yes. Owners can assess exit preparation, while buyers can use the same framework to evaluate the quality, risk, and transferability of a potential acquisition.

How many areas does the model evaluate?

The scorecard contains seven main categories and 24 subcategories, with a weighted score and letter grade for each main category and the business overall.

How often should the assessment be updated?

Run it at least annually, or quarterly when the company is actively improving exit readiness or preparing for a transaction.

Can advisors customize the scoring?

Yes. The supplied weights and thresholds provide a researched starting point, but users can adapt them for a client, industry, strategy, or exit objective.

Does this determine the exact value of a business?

No. It is an exit-readiness assessment rather than a formal appraisal or financial advice. Use your own data, judgment, and qualified advisors when making transaction decisions.

Know what stands between the business and a strong exit

Turn exit readiness into a measurable improvement plan.

Score 24 subcategories across seven business dimensions, customize the weights, and present the results in a clear, print-ready summary. One-time purchase for $65.

Get the Exit Readiness Model

What is Economic Vacancy in Real Estate Modeling

Economic vacancy refers to the financial impact of vacant space within a property as well as loss of income from other factors (concessions, bad debt, non-payers, below-market rent). It measures the income loss due to unoccupied units and other factors or spaces that are not generating rental revenue. This concept is crucial in real estate, particularly for property investors and managers, as it reflects the potential income shortfall resulting from vacancies.

What is "Loss to Lease" in Real Estate Modeling?

"Loss to Lease" in real estate is a term used primarily in the context of property management and investment, particularly in multifamily and commercial real estate. It refers to the difference between the actual rent being paid by tenants and the potential rent that could be obtained at current market rates. It could be positive or negative and yes I've seen situations where the existing rent is more than the market rents. It means there is less opportunity to improve rents.

Importance of Cost Allocation, Specifically Overhead Allocation

Cost allocation, particularly overhead allocation, is a critical task in accounting that involves distributing indirect costs to various departments, products, or cost centers. Overhead costs include expenses that are not directly tied to production, such as rent, utilities, and administrative salaries. Proper allocation of these costs is essential for accurate financial reporting, pricing, and strategic decision-making.