Overview

This model is profit and loss statement for general trading including comparison for the current month, year to date and full year by choosing the selection boxes in P&L Trend sheet below column O to identify the fiscal year and the current month

All the data should be entered in the in the green cells only to dynamically flow into P&L Trend and P&L comparison sheet

After you fill the green cells you will get the following below:

-Income statement by month

-Actual vs Budget for the current month

-Actual vs LYSP (Last year same period) for the current month

-Actual vs Budget YTD

-Actual vs LYSP YTD

-Actual vs Budget FY (Full year)

-Actual vs LYSP (Last year same period) for the full year

-Income statement for current year and last year

You can find the full instruction in the instruction sheet

Please message me for any inquiry

Share
Reviews Add a review
No reviews yet

More From eCorporateFinance

Browse our top rated business templates. See All
Dynamic Profit & Loss Comparison
1
236
1
General overview   This is most important tool to understand and identify the variance.   It will help the business…
Monthly Financial Model
397
1
The template has been constructed for monthly financial reporting for general trading industry, It is incredibly simple to use that…
Startup Business Plan for General Trading with Scenario Analysis
562
0
This model is startup business plan for general trading. It is very practical model to measure the financial performance over…
Startup Business Plan
1,533
0
This model has been constructed for startup business plan to support general trading. This model is very simple to use…
Heavy Machinery Trading Startup Business Plan
1,021
2
This model is startup business plan for heavy machinery trading to support 3 main industries, construction, mining and agricultural. It…
Cash Flow Projection for Rental Heavy Machinery - Excel Template
1,433
2
Rental machinery business is very critical business therefore the cash flow projection is necessary to keep your business moving This…
See All