Question about Microsoft Computers & Internet

2 Answers

How to do profit and loss a/c in ms excel

And how to do balance sheet in ms excel with what formulae

Posted by on

2 Answers

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Master
  • 728 Answers

Hi saleem_share,
I'm not sure why you would want to use excel to create a P&L, but the same formula would apply to excel as it would for a standard P&L. In one section of the spreadsheet add all of your income accounts. Then Subtract your cost of sales from that. That would equal your Gross Profit. After that add all the rest of your Expenses, and subtract from the Gross Profit, which would give you your net Profit or Loss Example:
Description
Amount
Formula
Sales Product A
1,000.00

Sales Product B
1,000.00

Total Sales
2,000.00
SUM(C1:C2)
Cost of Sales Product A
500.00

Cost of Sales Product B
200.00

Total Cost of Sales
700.00
SUM(C5:C6)
Gross Profit
1,300.00
SUM(C4-C7)



Auto
25.00

Utilities
50.00

Payroll
300.00

Office Supplies
20.00

Total Expenses
395.00

Net Profit
905.00
SUM(C8-C14)


I hope this helps

Mark

Posted on Jan 05, 2009

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

First define the name of your complete debit cell and credit cell.means 1st select all expences define with any name,and same with credit. than,go to the net profit cell and type formula =if(cell adress,"","","netprofit") same formula for net loss. than go to the net profit amount cell and type =if(sum(cell address)>sum(cell address),sum(cell address)-sum(cell address) than enter your formula run smoothly and apply same as net loss..... at last coputing total =sum(cell address) than enter..............

hope my effort help.......

Posted on Mar 07, 2011

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

What Financial Statements Will I Need When Applying For A Loan?


When getting a business loan, you need to prepare and understand primary financial statements. One is, balance sheet, that is a record of assets, liabilities and capital; and the other is profits (profit and loss) statements, an outline of your income and expenses over a given time frame.

Nov 18, 2016 | Computers & Internet

1 Answer

Want to copy formula into multiple excel sheets


why not? however, you can also insert an apostrophe (') at the start of the equation before copying the entire formula so that the formula will be treated as a text thus preserving all cell references. dont forget to remove the apostrophes after you have pasted them though for the formulas to work again.

Jul 29, 2009 | Computers & Internet

1 Answer

MS Excel-Values in the formula in place of cell reference


Copy the cell(s) and then right click on the cell(s). Choose Paste Special and then choose Value. That will convert it.

Jun 22, 2009 | Microsoft Excel for PC

1 Answer

EXCEL FORMULA


on sheet2!a1 type =sheet1!a1 - anything you type on sheet1!a1 will appear on sheet2!a1

Sep 17, 2008 | Computers & Internet

2 Answers

Excel formulas


type in "=" and then go to the cell in the 2nd sheet and click on the cell that contains the value you want carried to sheet 1. Then drag copy the forumula in sheet 1 to all the cells you want it to relate to. Now, if you place a value in e.g. A1 of sheet 2, then that same value will appear in A1 of sheet 1.
Good luck.

Sep 13, 2008 | Microsoft Computers & Internet

4 Answers

How many formulas we can use at a time in Excel


That depends on which version of Excel you are using.
Excel 2003 supports up to 65,335 formulas
Excel 2007 has no limit.
you can communicate between the worksheets which are contained by one workbook (one excel-file).
Communicating between files cannot be done with formula's.

Apr 04, 2008 | Microsoft Excel for PC

2 Answers

Formmulas are not appling in the excel of office xp


Dear chidambar, thats usually because you've mistakenly tampered with a file or because you're putting an inapplicable value. Can you tell me what error is it exactly ?

you might like to re-install your MS excel after backing up your files. You might also like to repaire your ms office from your cd.


if that has helped you plz press fixya.

Dec 13, 2007 | Computers & Internet

2 Answers

Excel 2003


Dear Thccsl, if you meant formulas by writing codings then you can find a complete list of formulas by clicking fx button beside the formula bar in MS excel. You can get complete range of forumlas and example and explanation of how to use this formula.

You also might like to see this for detailed information:

http://en.wikipedia.org/wiki/MS_excel

If this solution was helpful please press solved.

Nov 24, 2007 | Computers & Internet

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

607 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2642 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18357 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...