Finance and Business Analytics: practice exercises
Business-style tasks for finance and planning: loan payments with PMT, deposits and compound growth, NPV and IRR, Goal Seek, budgets, payroll calculations and sales reports. Each exercise sets up a small realistic scenario and asks for a specific number or formula, so you practice the same logic you would use at work. The automatic check accepts any correct approach, which makes it easy to compare your formula with alternatives afterwards.
72 exercises · level: Analyst
Start with the first task Study the course: Finance and Business Analytics →
Showing 72 of 72
Financial Math
In B5, calculate the monthly payment.
In B6, calculate how much you will pay in total.
In B7, calculate the total interest on the loan.
Change the term in B3 to 360 months (30 years): the payment drops, but the interest grows.
In B6, calculate the balance at the end of the term in B2.
In B7, calculate how much of your own money you pay in over the whole term.
In B8, calculate the interest earned.
In B11, calculate how much to deposit today (with no further deposits) to have the goal in B10 at the end of the term.
In B10, calculate the project's NPV.
In B11, calculate the IRR: the project's rate of return.
In B12, show "Accept" if the NPV is above zero, otherwise "Reject".
Find the loan amount in B1 for which the payment in B5 is exactly $1,800.
In B7, calculate the total interest for the loan amount you found.
In B5, calculate the annual interest rate of the installment plan (RATE × 12).
In B10, calculate how many months it takes to pay off the debt in B7 at the rate in B8 with the payment in B9.
In E7, calculate the return of the project whose cash flows arrive on different dates (D2:E5).
In B3, calculate the loan amount: the car price minus the down payment (B2 is a share of the price).
In B6, calculate the monthly loan payment.
In B7, calculate the total interest: all payments minus the loan amount.
In E4, calculate how much you will have saved over the term in E2 with the monthly deposit in E3 (no starting balance).
In E6, calculate how much to deposit today (no further deposits) to have the amount in E5 after E2 months.
Management Accounting and Analysis
In B4:D4, calculate gross profit: revenue minus cost of goods sold.
In B9:D9, calculate operating profit: gross profit minus rent, payroll, marketing and depreciation (rows 5–8).
In B10:D10, calculate income tax at the rate in G2. A loss-making month pays zero tax. Do not type the rate into the formula.
In B11:D11, calculate net profit.
In B14:D14, calculate the month's cash flow: net profit plus depreciation minus capital expenditure.
In B15:D15, calculate the cash at the end of each month. January starts from the amount in G3; every later month starts from the previous month's ending cash.
In B10, calculate the contribution margin per order: order value minus cost of goods (B3 of the order), shipping, and the fee (B5 of the order). Take the percentages from the cells.
In B11, calculate the contribution margin percentage: the share of the order value that is margin.
In B12, calculate CAC: the ad budget per new customer.
In B13, calculate LTV: the margin per order times the number of orders per customer lifetime.
In B14, calculate the LTV to CAC ratio.
In B15, show "Scale up" if LTV/CAC is at least the target in B9, otherwise "Fix the economics". Do not type the target into the formula.
In F2:F9, calculate each item's revenue for the year (the sum of the four quarters). The total in F10 calculates itself.
In G2:G9, calculate each item's share of the total revenue in F10.
In H2:H9, calculate the cumulative share: this item's share plus the shares of all items above it.
In I2:I9, assign the ABC class: "A" if the cumulative share is at most the threshold in B12, "B" if at most B13, otherwise "C". Do not type the thresholds into the formula.
In J2:J9, calculate the coefficient of variation of the quarterly sales: the standard deviation divided by the average.
In K2:K9, assign the XYZ class: "X" if the variation is at most B14, "Y" if at most B15, otherwise "Z".
Modeling and Optimization
In B8, show the name of the active scenario from B1:D1, using the number in G1.
In B9:B12, pull in the assumptions of the active scenario from the table (rows 2–5), using CHOOSE or INDEX with the number in G1.
In B13, calculate revenue for the month: cups per day × average ticket × operating days (G2).
In B14, calculate profit before tax: revenue less cost of goods (B11 of revenue), rent, and the costs in G3.
In B15, calculate net profit: profit before tax minus tax at the rate in G4 (no tax on a loss).
Switch the model to the worst case: type 1 in G1. See what happens to profit.
In B10, write the objective function, the profit for the day: profit per piece (B2:D2) × plan (B7:D7). While the plan is empty it shows 0.
In E3:E4, calculate how much of each resource the plan uses. Anchor the plan B7:D7 so the formula can be filled down.
In G3:G4, show "OK" if the resource used is no more than what is available, otherwise "Violated".
In B8:D8, check demand: "OK" if the plan is no more than the demand in row 5, otherwise "Violated".
Do Solver's job by hand: enter whole non-negative numbers in B7:D7, a plan where every check says "OK" and the profit in B10 is the maximum.
Business Projects
In B8 and C8, calculate the totals for the budget and the actual.
In D2:D7, calculate the variance of actual from budget.
In E2:E7, write "Over budget" if the variance is above zero, otherwise "Within budget".
In F2:F7, calculate each category's share of the actual spending, in percent format.
In G2:G4, calculate each rep's revenue.
In H2:H4, count each rep's deals.
In I2:I4, calculate the rep's share of total revenue (calculate the total right in the formula with SUM($D$2:$D$13)).
In J2:J4, calculate the average deal (revenue / deals), rounded to whole dollars.
In G6, calculate the sales for March 2026.
In G7, find the largest single deal for the whole period.
In F2:F9, pull each category's markup from the lookup table K2:L4.
In G2:G9, calculate the selling price: cost × (1 + markup), rounded up to the next 10 cents.
In H2:H9, write "Reorder" if the stock is below the minimum, otherwise "OK".
In I2:I9, calculate the value of the stock at cost (in stock × cost) and apply the currency format.
In L6, count how many items need reordering.
In L7, calculate the value of the stock in the "Beverages" category.
In E2:E4, pull in the assumptions of the active scenario (the number in J1) with INDEX or CHOOSE.
In B7:G7, calculate cups per day: in month 1 it is E2, and in each later month it is the previous month × (1 + the growth rate in E3).
In B8:G9, calculate revenue (cups × ticket E4 × days J6) and cost of goods (revenue × J2).
In B11:G13, build the P&L: profit before tax (revenue − cost of goods − fixed costs), tax at the rate in J4 (0 on a loss), and net profit.
In B14:G14, calculate the cumulative cash flow: it starts at minus the investment in J5, then each month adds net profit. The model must recalculate for any scenario in J1.
Unit economics: in B15, the margin per cup (ticket E4 × (1 − cost of goods J2)); in B16, the break-even point: how many cups a day cover the fixed costs J3 over J6 days (round up to a whole number).
No exercises match these filters.