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,
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
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
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,
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 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.
The declining balance depreciation method is an accelerated depreciation method that is used to decline the value of an asset quickly. In this method, the depreciation amount is higher for
