Sometimes we need to calculate the Loan Amount in Excel to borrow loan from Bank or some others company. There are many Banks and Financial Companies offered many kinds of Schemes. But before choosing anyone of them, you can simply calculate these scheme through Excel with few built-in functions, which will give you the real scenario. But before starting calculation you need to understand few Financial Terms. Some Financial Terms: PV (Present Value): This amount is basic. No interest or Tax included here. It is also known as Principal Value. FV (Future value): Based on Time Value of Money (TVM), it calculated for a specific period of time. It can be greater than PV or less than PV. Rate (Interest Rate %): It is the interest the set by the Bank. The Bank will take this interest as additional amount from your principal amount. Bank will mention it in contract as Annually. Make it sure from the Bank first. Assume that, Bank said Interest Rate is 12% Annually. Now you can con...
Learn Microsoft Excel with step by step tutorials including charts, formulas, functions, Power BI, Excel VBA for beginners.