Get instant live expert help on how to calculate total profit
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I do not know how to calculate a business profit
Solved by G. F. in 18 mins
21. In the Analysis section (rows 19-20), use cell references to display the total income and total expenses. In Row 21, calculate profit for all years in C21:T21.
Solved by K. H. in 24 mins
In the Profit Analysis Worksheet:
a. In the first cell directly under the Profit label, row-wise calculate total profit by subtracting Expenses from revenue (should be a positive number).
b. In the first cell directly under the ProfitperCar label, row-wise divide Profit by NumCars.
c. Adjust column widths as needed to eliminate truncation after formatting.
Solved by D. J. in 27 mins
Develop and enter the appropriate Excel formulas to calculate: the initial amount invested in each
stock, the profit (or loss) when you sold the shares of that firm, and Return on Investment (ROI).
D. For the entire portfolio: (1 pts)
i. Enter Excel formulas to calculate Total Amt Invested, Total Gain Amt (or Total Loss Amt) and Total
ROI of the entire portfolio. (Hint: Total ROI is not sum of individual ROIs. To compute the Total ROI
on the entire portfolio, use the total profit (or total loss) on the portfolio and the total amount invested.)
Solved by T. H. in 22 mins
In the Profit Analysis worksheet:
a. Create a Pivot Table using numeric data from Profit column.
b. Display the total profit for each of the four classes of cars.
c. Display the total profit for Airport as well as the Downtown location.
d. Row and column calculations (sum) are required so that the total profit for EACH location and the total profit for EACH carclass are visible in the pivot table. There must be a grand total (sum) that represents the sum of ALL profit.
Solved by T. D. in 23 mins