Knowee
Questions
Features
Study Tools

By using cell linking and freezing functions calculate profit for the year 2026Revenue of year 2020 is Rs. 30000Cost is 70 % of revenue in 2020 and expected to remain 70% of revenue in future also.Growth rate in revenue is 11% on year on year basis.

Question

By using cell linking and freezing functions calculate profit for the year 2026Revenue of year 2020 is Rs. 30000Cost is 70 % of revenue in 2020 and expected to remain 70% of revenue in future also.Growth rate in revenue is 11% on year on year basis.

🧐 Not the exact question you are looking for?Go ask a question

Solution

Sure, here are the steps to calculate the profit for the year 2026 using Excel:

  1. First, let's input the given data into Excel. In cell A1, type "Year". In cell B1, type "Revenue". In cell C1, type "Cost". In cell D1, type "Profit". In cell A2, type "2020". In cell B2, type "30000".

  2. Since the cost is 70% of the revenue, in cell C2, type "=B2*0.7" and press Enter. This will calculate the cost for the year 2020.

  3. The profit is calculated as Revenue - Cost. So, in cell D2, type "=B2-C2" and press Enter. This will calculate the profit for the year 2020.

  4. Now, let's calculate the revenue for the year 2021. Since the growth rate is 11%, in cell B3, type "=B2*1.11" and press Enter. This will calculate the revenue for the year 2021.

  5. Repeat steps 2 and 3 for the year 2021 by typing "=B3*0.7" in cell C3 and "=B3-C3" in cell D3.

  6. Now, you can drag the formulas in cells B3, C3, and D3 down to calculate the revenue, cost, and profit for the years 2022 to 2026.

  7. The profit for the year 2026 will be displayed in cell D8.

Remember to replace "B2", "C2", etc. with the actual cell numbers in your Excel sheet.

This problem has been solved

Similar Questions

Enter a formula in the selected cell to calculate the profit projection for 2022: total sales (cell F4) minus the cost of goods sold (cell F5).

Question 3You are working on the sales data for office desks and want to calculate the total profits for the year 2020. What function would you use to calculate the total profits, which are located in the cell range B2 to B220?1 point= TOTAL (B2 : B220)= B2 + B220= B2 : B220= SUM ( B2 : B220)

In what ratio should the profit of Rs.8000 be divided if X starts a business with an investment of Rs.20000, Y invests Rs.7500 for 4 months and Z invests Rs.15000 after 3 months from the start of the business.

Fixed cost Rs. 2,00,000; Sales Rs. 8,00,000; P/V Ratio 30%; the amount of' profit is .a.Rs. 35,000 .b.Rs. 40,000 .c.Rs. 45,000 .d.Rs. 50,000.

Sales Rs. 50,000; Variable cost Rs. 30,000; Net profit Rs. 6,000; fixed cost is .a.b. Rs. l4,000 .b.Rs. 10,000.c.Rs. 12,000.d.Rs. 8,000.

1/3

Upgrade your grade with Knowee

Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.