Finance & Business
Budgets, variance, margins, commissions, and invoices.
finance & business
Calculate Budget Variance in Dollars and Percent
Subtract budget from actual to get variance in dollars, then divide by budget to get variance percent for any line item.
=B2-A2finance & business
Calculate Profit Margin From Revenue and Cost
Divide profit by revenue to get profit margin — the share of every sale you actually keep — and avoid mixing it up with markup.
=(B2-A2)/B2finance & business
Calculate an Invoice Due Date From Payment Terms
Add your payment terms to the invoice date — like =B2+30 for net-30 — to get due dates that update automatically.
=B2+30finance & business
Calculate a Monthly Loan Payment with PMT
PMT returns the fixed monthly payment on a loan from the rate, term, and amount — the fast answer to what a loan costs per month.
=PMT(6%/12,60,-25000)