To ensure that the customers get the right price for the products, it is important to calculate the sales tax. While the US doesn’t have a ruling for the maximum retail price, sales tax is applied ...
GST (Goods and Services Tax) reconciliation is done to know whether the tax collected/paid when purchasing/selling something matches the CRA records of the government. In Excel, we can use various ...
Creating and following a personal budget is a smart decision for any finance-literate person. A budget can help you track your income and expenses, and plan for the future. Excel, being a spreadsheet ...
To determine a product’s sales target, it is important to calculate the break-even point. A break-even chart is the visual representation of the break-even analysis. Using the fixed cost, variable ...
If you are taking a loan to buy a home, you would have to pay the loan back through equated monthly installments. A home loan is one of the most popular and the largest loans people take in their ...
A payback period is the time an investment takes to break even. A discounted payback period is when the cash flow is discounted to comply with the time value of money. Imagine you have an investment ...
Calculating the future value of an annuity helps you measure the value of a series of payments over time. For example, if you open a DPS account at a bank, you will be required to pay a specific ...
To monitor your stocks, you might want to track the stock portfolio. In Excel, it is easy to create a sheet that will help you track the sharemarket status and the condition of your stocks. In this ...
The dividend discount model is used to determine the appropriate price of a stock by considering the present value of the future dividends that the stock is expected to pay. Imagine that you are ...
