Essay On P&L Deshpande Download

Free Profit and Loss template (P&L template)

Download CFI’s free Profit and Loss template (P&L template) to easily create your own income statement.  After downloading the Excel file, simply enter your own information in all of the blue font color cells which will automatically produce a monthly or annual statement as the output.  The Excel file includes 4 templates.

A statement of profit and loss (also called in Income Statement) summarizes a company income and expenses for a period of time to arrive at its net earnings for the period.

>Click here to download the template<.



How to use the Profit and Loss templates

Here are the steps to follow to effectively use your templates:

  1. Download the Excel file
  2. Use the monthly or annual worksheet, depending on what type of statement you want to produce
  3. Replace all the blue cells that contain hardcoded numbers with your company’s information
  4. Double check to ensure all the formulas in black cells working properly
  5. Save as a new file and consider saving a version as PDF as well as XLS

The two types of templates included in the file are shown below.


#1 Monthly Profit and Loss template (P&L template)

The monthly P&L template is perfect for businesses that require regular reporting and detail.  By showing all of the information in a series of monthly columns, much more detail is visible than if only the annual figures were shown.

The monthly profit and loss template is perfect for small, medium and large businesses as it can easily be adjusted to add or eliminate detail as required.

Click on the image of the statement below to download the Excel file.



#2 Annual Profit and Loss template (P&L template)

For businesses that have been in operation for several years, it may be helpful to show an annual (full year or year to date) statement.  The annual profit and loss template below follows the same format and structure as the monthly version, however, it doesn’t have a total column at the end that sums up each of the periods.

This template is ideal for any size business and can easily be changed by adding or removing line items (rows) as necessary.

Click on the screenshot below of the annual P&L template to download a free copy of the Excel file.



Components of the template

While each income statement is unique to every company, there are many common line items that you will see over and over again.

The most common P&L line items include:


How to modify the Profit and Loss template (P&L template)

All the templates included in the free Excel file can be easily edited and changed to suit your own business.

If you require more line items, simply insert additional rows in the section where you need to add revenues or expenses.  Then check to make sure the formulas adding up the totals capture those new rows.

If you need to remove line items from the templates, simply delete unnecessary rows and ensure all formulas are still working properly.

To learn more about the details of financial reporting, check out PWC’s free guide to financial statement presentation


Additional resources

Thank you for checking out CFI’s free templates for making your own annual and monthly P&L statements in Excel.  To keep learning and advancing your career as a financial analyst, these additional resources will be helpful:

This page contains Indic text. Without rendering support you may see irregular vowel positioning and a lack of conjuncts. More...

This person article needs cleanup. Please review Wikiquote:Templates, especially the standard format of people articles, to determine how to edit this article to conform to a higher standard of article quality. You should also check this article's talk page to see if the person who added this message left an explanation there. This page has been listed as needing cleanup since 2011-09-07.

P. L. Deshpande (November 8, 1919 – June 12, 2000) was a noted Indian writer in Marathi. He was also famous as an orator and performing artist. He wrote as Pu La (IPA: /pʊ.ɫ/) Deshpande, from his initials in Marathi.

From his various literature[edit]

  • शेवटी काय हो, आपण पत्त्याच्या नावाचे धनी, मजकुराचा मालक निराळाच.
    • Translation:In a letter, all we own is the address on the envelope. The contents are a matter of fate.
    • Alternate translation: Ultimately, it may be our name on the envelope, but someone else (God) is the one who wrote the message.
    • Pu La had a penchant for ending his humourous works with thought-provoking punchlines. In this quote from his work Post Office, he sums up on how life is a lot like the the letters that pass through the post office.
  • झाले ! म्हणजे प्रश्नातून सुटका नाही. माझीच नव्हे, कुणाचीच नाही! मग जगणे म्हणजे नुसते श्वासोच्छ्वास घेणे की लक्ष लक्ष प्रश्नांच्या उत्तरांमागून धावणे? शेवटी प्रश्न म्हणजे तरी काय आणि उत्तर म्हणजे तरी काय? हादेखील एक प्रश्नच. मी त्या प्रश्नचिन्हाकडेच निरखून पाहतो. आणि युरेका! त्या प्रश्नचिन्हातच माझे उत्तर कसल्याशा सांकेतिक भाषेत दडवले आहे हे मला ठाऊक नव्हते. प्रश्नचिन्हाच्या त्या आकड्याखालीच शून्य हे त्याचे उत्तरही असते. विरामिचन्हे इतकी विचारपूर्वक बनवली असतील याची मला कल्पना नव्हती!
    • Translation: Alas! So there is no escape from the question. Not for me, not for anyone! Then life is just breathing or running behind infinite number of questions? And then, what question is really ? And what answer is too? This too a question. I observe the question mark carefully. And Eureka ! I didn't know that my answer was encrypted and hidden in that symbol of a question mark. The dot below the curved stroke in a question mark symbolizes Zero as the question's answer itself, I never knew. Punctuation marks are so carefully crafted, I never knew![citation needed]
  • जगात काय बोलत आहात ह्यापेक्षा कोण बोलत आहात ह्याला जास्त महत्त्व आहे.
    • Translation: In this world, "who is saying", is more important than "what is being said" !
    • Alternate translation: In this world, who you are is more important than what you are saying.
    • Source: Asa mi Asami
  • प्रयास हा प्रतिभेचा प्राणवायू आहे.
    • Translation: Effort is the oxygen for talent.
    • Source: These words are uttered by the lead character of his work with the same name - Sakharam Gatne.
  • लग्नापुर्वी शी न लूक्ड सो … लुकडी!
    • Translation: Before marriage, she looked so .. (Pu La completes) Thin!
    • In his hilarious work 'Mi ani majha shatrupaksha' (Me and my enemy party), Pu La criticizes people who bore others by telling them accounts of their travels, showing them pictures of holidays or discussing their housing construction plans. This particular quote is from a situation when the author is forced to sit through a painfully slow and boring display of old photographs by a husband and wife.
    • It is a play on the English word "looked" and the Marathi word "thin", which is pronounced "lukdi". The character who speaks the first part of the quote is intermingling English and Marathi in the lines.
  • मी लंडन मध्ये हमाली करून वजनी पाउंड घटवून चलनी पाउंड कमवावेत, असही सुचवण्यात आलं.
    • Translation: It was also suggested that, In London, I should work as a porter to gain some monetary pounds while losing some pounds in weight.
    • In his travelogue Apoorvai (अपूर्वाइ), Pu La describes the non-stop flow of advice before traveling to London. This quote is one advice given to him on learning on how many pounds porters charge for carrying baggage on train stations in London.
  • परिस्थिति हा अश्रूंचा कारखाना आहे!.
    • Translation:Circumstance is a factory of tears.
    • Source: These words are uttered by the lead character of his work with the same name - Sakharam Gatne.

External links[edit]


Leave a Reply

Your email address will not be published. Required fields are marked *