Calculating net income in Excel is essential for anyone looking to understand their financial performance, and income-partners.net provides the tools to simplify this process. Mastering this skill involves understanding key financial metrics and utilizing Excel’s powerful functions to accurately determine your earnings after all expenses. This article will show you how to calculate net income using various Excel functions, handle complex financial scenarios, and avoid common mistakes, ensuring you can make informed decisions and boost your profitability, and grow your bottom line. Let’s dive in with profit margin, revenue streams, and expense tracking!
1. Understanding Net Income and Its Importance
Net income, often referred to as the bottom line, represents the profitability of a business after accounting for all revenues and expenses. It’s a critical metric for evaluating financial health and making informed decisions.
1.1 What is Net Income?
Net income is the amount of profit a company earns after deducting all expenses, including the cost of goods sold, operating expenses, interest, and taxes, from its total revenue. According to a report by Harvard Business Review, understanding net income is crucial for assessing a company’s ability to generate profits and manage its financial obligations.
- Definition: Profitability after all expenses are paid.
- Synonyms: Net profit, bottom line, earnings.
1.2 Why is Net Income Important?
Net income serves as a vital indicator of a company’s financial performance and stability. It is used by investors, creditors, and management to evaluate the efficiency and profitability of the business.
- Investor Perspective: Investors use net income to assess the company’s earnings potential and make investment decisions. A consistently growing net income indicates a healthy and profitable business, attracting more investors.
- Creditor Perspective: Creditors analyze net income to determine the company’s ability to repay debts. A higher net income suggests a greater capacity to meet financial obligations.
- Management Perspective: Management uses net income to evaluate operational efficiency and make strategic decisions. It helps in identifying areas for cost reduction and revenue enhancement.
1.3 How Net Income Impacts Business Decisions?
Net income significantly influences various business decisions, affecting both short-term and long-term strategies.
- Investment Decisions: A strong net income can encourage investments in new projects, expansion, and research and development.
- Operational Efficiency: Analyzing net income trends helps in identifying operational inefficiencies and areas for improvement.
- Financial Planning: Accurate net income calculations are essential for budgeting, forecasting, and financial planning.
2. Setting Up Your Excel Spreadsheet
To calculate net income in Excel effectively, it’s essential to organize your data in a structured and clear manner. This involves setting up columns for revenue and expenses and ensuring the spreadsheet is easy to read and update.
2.1 Structuring Your Data
Start by creating a well-organized table with columns for different types of revenue and expenses. This structure will make it easier to input and analyze your financial data.
- Column Headers:
- Date: To track when the revenue or expense occurred.
- Description: Detailed explanation of the transaction.
- Revenue: Income generated from sales, services, or other sources.
- Expenses: Costs incurred, such as rent, utilities, salaries, and supplies.
2.2 Identifying Key Revenue Sources
List all sources of revenue to get a comprehensive view of your income streams. This helps in understanding which areas contribute most to your overall revenue.
- Examples of Revenue Sources:
- Sales Revenue: Income from selling products.
- Service Fees: Income from providing services.
- Interest Income: Income from investments or savings.
- Rental Income: Income from renting out properties.
- Other Income: Any additional income not categorized above.
2.3 Listing All Types of Expenses
Create a detailed list of all expenses to ensure an accurate calculation of net income. Categorizing expenses helps in identifying areas where costs can be reduced.
- Examples of Expenses:
- Cost of Goods Sold (COGS): Direct costs related to producing goods.
- Rent: Cost of renting office or business space.
- Utilities: Costs for electricity, water, and gas.
- Salaries: Wages paid to employees.
- Marketing Expenses: Costs for advertising and promotion.
- Maintenance: Costs for repairs and upkeep of assets.
- Depreciation: Decrease in the value of assets over time.
- Interest Expense: Cost of borrowing money.
- Taxes: Payments to government entities.
2.4 Example Spreadsheet Setup
Here’s an example of how your spreadsheet might look:
| Date | Description | Revenue ($) | Expenses ($) |
|---|---|---|---|
| 2024-01-01 | Sales Revenue | 10,000 | |
| 2024-01-05 | Service Fees | 5,000 | |
| 2024-01-10 | Rent | 2,000 | |
| 2024-01-15 | Salaries | 3,000 | |
| 2024-01-20 | Utilities | 500 | |
| Totals | 15,000 | 5,500 |
This table provides a clear and organized view of your financial data, making it easier to apply formulas and calculate net income accurately.
3. Inputting Data Into Excel
With the columns ready, it’s time to input your data. Enter all your revenue sources in one column and expenses in another. Be as detailed as possible to ensure accuracy in your calculations.
3.1 Entering Revenue Data
Input all revenue sources into the designated column. Ensure each entry is accurate and corresponds to the correct date and description.
- Example:
- Sales Revenue: $10,000
- Service Fees: $5,000
- Interest Income: $500
3.2 Entering Expense Data
Input all expenses into the designated column. Provide detailed descriptions for each expense to facilitate analysis.
- Example:
- Rent: $2,000
- Salaries: $3,000
- Utilities: $500
- Marketing Expenses: $300
3.3 Importance of Accurate Data Entry
Accuracy in data entry is crucial for correct net income calculations. Errors can lead to misinterpretations and poor financial decisions.
- Double-Check Entries: Always double-check each entry to ensure accuracy.
- Use Consistent Formatting: Maintain consistent formatting for dates and numbers.
- Regular Updates: Update your spreadsheet regularly to keep your financial data current.
3.4 Example of Detailed Data Entry
| Date | Description | Revenue ($) | Expenses ($) |
|---|---|---|---|
| 2024-01-01 | Sales Revenue | 10,000 | |
| 2024-01-05 | Service Fees | 5,000 | |
| 2024-01-08 | Interest Income | 500 | |
| 2024-01-10 | Rent | 2,000 | |
| 2024-01-15 | Salaries | 3,000 | |
| 2024-01-20 | Utilities | 500 | |
| 2024-01-25 | Marketing Expenses | 300 | |
| Totals | 15,500 | 5,800 |
Entering detailed and accurate data ensures that your net income calculations are reliable and provide valuable insights into your financial performance.
4. Using Basic Formulas for Net Income
Now comes the fun part—calculations! The basic formula for net income is:
Net Income = Total Revenue - Total ExpensesTo do this in Excel, we use the SUM function, which is a lifesaver when dealing with numbers. Here’s a step-by-step on how to calculate net income:
4.1 SUM Function for Total Revenue
The SUM function is used to add up all the values in a specified range of cells. This is essential for calculating total revenue.
- Formula:
=SUM(range) - Example: If your revenue values are in cells B2 to B10, the formula would be
=SUM(B2:B10).
4.2 SUM Function for Total Expenses
Similarly, the SUM function is used to add up all expenses.
- Formula:
=SUM(range) - Example: If your expense values are in cells C2 to C10, the formula would be
=SUM(C2:C10).
4.3 Calculating Net Income
To calculate net income, subtract total expenses from total revenue.
- Formula:
=Total Revenue - Total Expenses - Example: If total revenue is in cell B11 and total expenses are in cell C11, the formula would be
=B11 - C11.
4.4 Step-by-Step Calculation
- Enter Revenue Data: Input all revenue amounts into column B (B2:B10).
- Enter Expense Data: Input all expense amounts into column C (C2:C10).
- Calculate Total Revenue: In cell B11, enter the formula
=SUM(B2:B10). - Calculate Total Expenses: In cell C11, enter the formula
=SUM(C2:C10). - Calculate Net Income: In cell D11, enter the formula
=B11 - C11.
Example Spreadsheet with Formulas
| Date | Description | Revenue ($) | Expenses ($) |
|---|---|---|---|
| 2024-01-01 | Sales Revenue | 10,000 | |
| 2024-01-05 | Service Fees | 5,000 | |
| 2024-01-08 | Interest Income | 500 | |
| 2024-01-10 | Rent | 2,000 | |
| 2024-01-15 | Salaries | 3,000 | |
| 2024-01-20 | Utilities | 500 | |
| 2024-01-25 | Marketing Expenses | 300 | |
| Totals | 15,500 | 5,800 | |
| Net Income | 9,700 |
- Cell B11 (Total Revenue):
=SUM(B2:B8) - Cell C11 (Total Expenses):
=SUM(C2:C8) - Cell D11 (Net Income):
=B11 - C11
Using these basic formulas, you can easily calculate net income in Excel and gain valuable insights into your financial performance.
5. Automating Calculations with Excel Functions
One of Excel’s greatest strengths is its ability to automate repetitive calculations with functions. Once you’ve set up your basic net income formula, you can use it across different sheets or datasets without redoing everything.
5.1 Cell References for Dynamic Calculations
Using cell references instead of hard-coded numbers makes your Excel sheet dynamic. Whenever you update the figures in your revenue or expenses, the net income will automatically adjust.
- Example: If your total revenue is in cell B11 and your total expenses in C11, your formula should look like this:
=B11 - C11.
5.2 Fill-Down Options for Multiple Periods
If you’re dealing with multiple periods (e.g., monthly reports), using fill-down options will save time. Create the formula once, then drag it across the cells for each period. Excel handles the rest, so you can focus on analysis instead of number crunching.
- Steps:
- Enter the formula
=B11 - C11in cell D11. - Select cell D11.
- Click and drag the small square at the bottom right corner of the cell down to apply the formula to other rows.
- Enter the formula
5.3 Using Named Ranges
Named ranges make your formulas more readable and easier to understand. You can assign names to specific cells or ranges of cells.
-
Steps to Define a Named Range:
- Select the range of cells you want to name (e.g., B2:B10 for Revenue).
- Click in the Name Box (left of the formula bar).
- Type the name (e.g., TotalRevenue) and press Enter.
-
Using Named Ranges in Formulas:
- Instead of
=SUM(B2:B10), you can use=SUM(TotalRevenue). - The net income formula becomes
TotalRevenue - TotalExpenses.
- Instead of
5.4 Example of Automated Calculation
| Month | Revenue ($) | Expenses ($) | Net Income ($) |
|---|---|---|---|
| January | 15,500 | 5,800 | 9,700 |
| February | 16,000 | 6,000 | 10,000 |
| March | 17,000 | 6,500 | 10,500 |
| April | 18,000 | 7,000 | 11,000 |
- Formula in D2 (Net Income for January):
=B2 - C2 - Drag the formula down to apply to February, March, and April.
Automating calculations with Excel functions not only saves time but also reduces the risk of errors, allowing you to focus on analyzing and interpreting your financial data.
6. Handling More Complex Financial Scenarios
Sometimes, your financial data might be more complex, involving depreciation, taxes, or non-operating income. Excel can handle these intricacies with more advanced functions and formulas.
6.1 Accounting for Taxes
If you need to account for taxes, you can add an extra column for tax expenses and modify your formula.
-
Steps:
- Add a column for “Taxes” in your spreadsheet.
- Enter the tax amounts for each period.
- Modify your net income formula to subtract taxes.
-
Formula:
=Total Revenue - Total Expenses - Taxes -
Example: If taxes are in cell D2, the formula in cell E2 (Net Income) would be
=B2 - C2 - D2.
6.2 Calculating Depreciation
Depreciation is the decrease in the value of an asset over time. Excel has built-in functions to calculate depreciation.
-
Common Depreciation Functions:
-
SLN (Straight Line Depreciation): Calculates straight-line depreciation.
- Formula:
=SLN(cost, salvage, life) - cost: The initial cost of the asset.
- salvage: The salvage value of the asset at the end of its useful life.
- life: The useful life of the asset in years.
- Formula:
-
DB (Declining Balance Depreciation): Calculates depreciation using the declining balance method.
- Formula:
=DB(cost, salvage, life, period, [month]) - cost: The initial cost of the asset.
- salvage: The salvage value of the asset at the end of its useful life.
- life: The useful life of the asset in years.
- period: The period for which you want to calculate depreciation.
- month: (Optional) The number of months in the first year.
- Formula:
-
DDB (Double-Declining Balance Depreciation): Calculates depreciation using the double-declining balance method.
- Formula:
=DDB(cost, salvage, life, period, [factor]) - cost: The initial cost of the asset.
- salvage: The salvage value of the asset at the end of its useful life.
- life: The useful life of the asset in years.
- period: The period for which you want to calculate depreciation.
- factor: (Optional) The rate at which the balance declines. If omitted, it defaults to 2 (double-declining).
- Formula:
-
-
Example:
- Cost of Asset: $50,000
- Salvage Value: $10,000
- Useful Life: 5 years
- Straight-Line Depreciation:
=SLN(50000, 10000, 5)= $8,000 per year
6.3 Incorporating Non-Operating Income and Expenses
Non-operating income and expenses are those not related to the primary business operations. These include interest income, interest expense, and gains or losses from the sale of assets.
-
Steps:
- Add columns for non-operating income and expenses.
- Include these in your net income calculation.
-
Formula:
=Total Revenue + Non-Operating Income - Total Expenses - Non-Operating Expenses - Taxes -
Example:
| Item | Amount ($) |
|---|---|
| Total Revenue | 100,000 |
| Total Expenses | 60,000 |
| Non-Operating Income | 5,000 |
| Non-Operating Expenses | 2,000 |
| Taxes | 10,000 |
| Net Income | 33,000 |
- Formula:
=100000 + 5000 - 60000 - 2000 - 10000
By integrating these elements, your net income calculations remain accurate and reflective of real-world conditions. It’s a powerful way to see the complete picture of your finances.
6.4 Example: Comprehensive Net Income Calculation
| Item | Amount ($) |
|---|---|
| Total Revenue | 200,000 |
| Cost of Goods Sold | 80,000 |
| Operating Expenses | 50,000 |
| Depreciation | 10,000 |
| Interest Expense | 5,000 |
| Taxes | 15,000 |
| Non-Operating Income | 8,000 |
| Net Income | 48,000 |
This comprehensive approach ensures that your net income calculations are accurate and provide a true reflection of your financial performance.
7. Advanced Excel Techniques for Net Income Analysis
To enhance your net income analysis, consider using more advanced Excel techniques such as pivot tables, charts, and conditional formatting.
7.1 Using Pivot Tables
Pivot tables allow you to summarize and analyze large datasets quickly. They are useful for categorizing and aggregating revenue and expenses.
-
Steps to Create a Pivot Table:
- Select your data range.
- Go to the “Insert” tab and click “PivotTable.”
- Choose where you want the pivot table to be placed (new worksheet or existing worksheet).
- Drag the fields (e.g., Date, Description, Revenue, Expenses) to the appropriate areas (Rows, Columns, Values).
-
Example:
- Drag “Date” to the Rows area to analyze net income by month.
- Drag “Revenue” and “Expenses” to the Values area to sum these amounts.
7.2 Creating Charts and Graphs
Visualizing your data with charts and graphs makes it easier to identify trends and patterns. Excel offers various chart types, such as line charts, bar charts, and pie charts.
-
Steps to Create a Chart:
- Select the data range you want to chart.
- Go to the “Insert” tab and choose a chart type.
- Customize the chart with titles, labels, and legends.
-
Example:
- Create a line chart to track net income over time.
- Create a bar chart to compare revenue and expenses by category.
- Create a pie chart to show the distribution of expenses.
7.3 Conditional Formatting
Conditional formatting allows you to highlight cells based on certain criteria. This can help you quickly identify areas of concern or success.
-
Steps to Apply Conditional Formatting:
- Select the range of cells you want to format.
- Go to the “Home” tab and click “Conditional Formatting.”
- Choose a rule (e.g., Highlight Cells Rules, Top/Bottom Rules).
- Set the criteria and formatting options.
-
Example:
- Highlight net income values greater than $10,000 in green.
- Highlight expense values greater than $5,000 in red.
7.4 Example: Net Income Analysis Dashboard
Combine pivot tables, charts, and conditional formatting to create a dynamic dashboard for net income analysis.
This dashboard provides a comprehensive view of your financial performance, allowing you to quickly identify trends, patterns, and areas for improvement.
8. Common Mistakes to Avoid
Calculating net income accurately is crucial for making informed financial decisions. Avoiding common mistakes ensures that your calculations are reliable and provide valuable insights.
8.1 Data Entry Errors
Inaccurate data entry is a primary cause of errors in net income calculations.
- Solution:
- Double-Check Entries: Always double-check each entry to ensure accuracy.
- Use Data Validation: Use Excel’s data validation feature to restrict the type of data that can be entered into a cell.
8.2 Incorrect Formulas
Using incorrect formulas can lead to significant errors in your calculations.
- Solution:
- Verify Formulas: Always verify that your formulas are correct and reference the appropriate cells.
- Use Named Ranges: Using named ranges can make your formulas more readable and less prone to errors.
8.3 Overlooking Expenses
Failing to include all relevant expenses in your calculations can result in an overestimation of net income.
- Solution:
- Comprehensive List: Create a comprehensive list of all possible expenses.
- Regular Review: Regularly review your expense list to ensure it includes all current expenses.
8.4 Not Accounting for Depreciation
Failing to account for depreciation can distort your net income calculations, especially for businesses with significant fixed assets.
- Solution:
- Track Assets: Maintain a detailed record of all fixed assets and their depreciation schedules.
- Use Depreciation Functions: Utilize Excel’s built-in depreciation functions (SLN, DB, DDB) to calculate depreciation accurately.
8.5 Ignoring Non-Operating Items
Ignoring non-operating income and expenses can provide an incomplete picture of your financial performance.
- Solution:
- Identify Non-Operating Items: Identify all non-operating income and expenses.
- Include in Calculations: Include these items in your net income calculations to provide a more accurate representation of your financial performance.
8.6 Example: Corrected Net Income Calculation
| Item | Incorrect Amount ($) | Corrected Amount ($) |
|---|---|---|
| Total Revenue | 200,000 | 200,000 |
| Cost of Goods Sold | 80,000 | 80,000 |
| Operating Expenses | 50,000 | 50,000 |
| Depreciation | 0 | 10,000 |
| Interest Expense | 0 | 5,000 |
| Taxes | 15,000 | 15,000 |
| Non-Operating Income | 0 | 8,000 |
| Net Income | 55,000 | 48,000 |
- Incorrect Net Income: 200,000 – 80,000 – 50,000 – 15,000 = $55,000
- Corrected Net Income: 200,000 – 80,000 – 50,000 – 10,000 – 5,000 – 15,000 + 8,000 = $48,000
Avoiding these common mistakes ensures that your net income calculations are accurate and provide a reliable basis for financial decision-making.
9. Real-World Examples and Case Studies
To illustrate the practical application of calculating net income in Excel, let’s explore some real-world examples and case studies.
9.1 Case Study 1: Small Retail Business
A small retail business, “The Corner Store,” wants to calculate its net income for the year to assess its financial performance.
-
Data:
- Total Revenue: $300,000
- Cost of Goods Sold: $120,000
- Operating Expenses: $80,000
- Depreciation: $10,000
- Interest Expense: $5,000
- Taxes: $20,000
-
Excel Calculation:
| Item | Amount ($) |
|---|---|
| Total Revenue | 300,000 |
| Cost of Goods Sold | 120,000 |
| Operating Expenses | 80,000 |
| Depreciation | 10,000 |
| Interest Expense | 5,000 |
| Taxes | 20,000 |
| Net Income | 65,000 |
-
Net Income Calculation: 300,000 – 120,000 – 80,000 – 10,000 – 5,000 – 20,000 = $65,000
-
Analysis: The Corner Store has a net income of $65,000, indicating a profitable year. This information can be used to make decisions about investments, cost reduction, and expansion.
9.2 Case Study 2: Service-Based Business
A service-based business, “Tech Solutions,” wants to analyze its net income to identify areas for improvement.
-
Data:
- Total Revenue: $500,000
- Salaries: $200,000
- Rent: $30,000
- Utilities: $10,000
- Marketing Expenses: $40,000
- Taxes: $30,000
-
Excel Calculation:
| Item | Amount ($) |
|---|---|
| Total Revenue | 500,000 |
| Salaries | 200,000 |
| Rent | 30,000 |
| Utilities | 10,000 |
| Marketing Expenses | 40,000 |
| Taxes | 30,000 |
| Net Income | 190,000 |
-
Net Income Calculation: 500,000 – 200,000 – 30,000 – 10,000 – 40,000 – 30,000 = $190,000
-
Analysis: Tech Solutions has a net income of $190,000. By analyzing the expenses, the business can identify areas to reduce costs and increase profitability.
9.3 Real-World Example: Startup Company
A startup company, “Green Innovations,” uses Excel to track its net income monthly.
-
Data: (Monthly)
- Revenue: $20,000
- Expenses: $15,000
-
Excel Calculation:
| Month | Revenue ($) | Expenses ($) | Net Income ($) |
|---|---|---|---|
| January | 20,000 | 15,000 | 5,000 |
| February | 22,000 | 16,000 | 6,000 |
| March | 25,000 | 17,000 | 8,000 |
-
Net Income Calculation (January): 20,000 – 15,000 = $5,000
-
Analysis: Green Innovations uses this monthly net income data to track its growth and make informed decisions about investments and expenses.
These real-world examples and case studies demonstrate the practical application of calculating net income in Excel for various types of businesses. By accurately tracking revenue and expenses, businesses can gain valuable insights into their financial performance and make informed decisions.
10. Utilizing income-partners.net for Partnering and Increased Income
Now that you understand How To Calculate Net Income In Excel, it’s time to explore how income-partners.net can help you find strategic partnerships to boost your revenue.
10.1 How income-partners.net Can Help
income-partners.net is designed to connect businesses and individuals seeking to collaborate and increase their income. By joining the platform, you gain access to a diverse network of potential partners.
- Finding Strategic Partners: Identify partners with complementary skills and resources to expand your business reach.
- Exploring New Opportunities: Discover new business ventures and investment prospects.
- Building Relationships: Establish trust-based relationships with potential partners to foster long-term growth.
10.2 Types of Partnerships Available
income-partners.net offers a variety of partnership opportunities to suit your business needs:
- Strategic Partnerships: Collaborate with other businesses to achieve mutual goals.
- Joint Ventures: Pool resources to launch new projects or ventures.
- Affiliate Partnerships: Earn commissions by promoting other businesses’ products or services.
- Distribution Partnerships: Expand your distribution network to reach new markets.
10.3 Benefits of Partnering Through income-partners.net
- Increased Revenue: Access new markets and customers through partnerships.
- Reduced Costs: Share resources and expenses with partners to lower operational costs.
- Enhanced Expertise: Benefit from the skills and knowledge of your partners.
- Risk Mitigation: Share risks and responsibilities with partners to reduce individual exposure.
10.4 Example: Partnering for Growth
A marketing agency, “Creative Solutions,” partners with a software company, “Tech Innovators,” through income-partners.net.
-
Creative Solutions: Provides marketing services to promote Tech Innovators’ software.
-
Tech Innovators: Offers Creative Solutions access to its software for marketing campaigns.
-
Results:
- Creative Solutions increases its revenue by offering specialized marketing services for software.
- Tech Innovators expands its customer base through effective marketing campaigns.
10.5 Call to Action
Ready to take your business to the next level? Visit income-partners.net today to explore partnership opportunities and start building relationships that will drive your income growth. Join our community of like-minded professionals and discover the power of collaboration.
- Explore Opportunities: Browse our extensive database of potential partners.
- Build Relationships: Connect with other businesses and individuals to discuss partnership opportunities.
- Start Growing: Take the first step towards increased revenue and business success.
By leveraging the resources and network available on income-partners.net, you can unlock new opportunities for growth and achieve your financial goals. Don’t wait—start your journey to successful partnerships today!
FAQ: How To Calculate Net Income In Excel
1. What is net income and why is it important?
Net income, often called the bottom line, is a company’s profit after deducting all expenses from total revenue; it’s important because it shows a company’s true profitability and financial health.
2. How do I set up an Excel spreadsheet to calculate net income?
Set up columns for date, description, revenue, and expenses; list revenue sources and expense types to organize your data effectively.
3. What is the basic formula for calculating net income in Excel?
The basic formula is Net Income = Total Revenue - Total Expenses, use the SUM function to calculate total revenue and total expenses, then subtract expenses from revenue.
4. How can I automate net income calculations in Excel?
Use cell references and fill-down options for dynamic calculations; cell references update automatically when data changes, and fill-down applies formulas across multiple periods.
5. How do I account for taxes in my net income calculation?
Add a column for taxes and modify the net income formula to Net Income = Total Revenue - Total Expenses - Taxes, ensuring an accurate reflection of your after-tax profit.
6. What are some advanced Excel techniques for net income analysis?
Use pivot tables to summarize data, create charts for visualization, and apply conditional formatting to highlight key metrics; these tools offer deeper insights into financial performance.
7. What are common mistakes to avoid when calculating net income in Excel?
Avoid data entry errors, incorrect formulas, overlooking expenses, not accounting for depreciation, and ignoring non-operating items; these oversights can skew your net income results.
8. Can you provide a real-world example of calculating net income in Excel?
A retail business with $300,000 in revenue, $200,000 in expenses, and $20,000 in taxes calculates net income as $300,000 – $200,000 – $20,000 = $80,000.
**9. How
