So if we wanted the spreadsheet to handle ad hoc extra payments and interest only periods? Add column for extra payment between "Capital" and "Balance" columns, then add any value in that new column to the "capital payment" to deduct from the balance each period? If there is an interest only period, manually delete the "capital" portion of each payment where that applies, so only interest is paid, and the balance does not reduce at all during those periods? Would that work?
Nice Video, thank you. however I encountered a problem where both arrows (shift up and shift down) both occur at the left bottom corner and I cannot turn the calculator off, and all the resets do not work. :(
My return has been rejected because the employer capture the incorrect Tax directive number on my IRP5 which does not match SARS record. That i will have manually update the correct IRP5 from the employer or the company must send it to SARS first?
Very well explained. But in second example, it still returns annual yield to maturity and to get semi annual yield to maturity rate, one need to divide it by 2. Is there a way to get the YTM by payment period?
I thought under absorption is like an expense so we subtract it from the gross profit and the over absorption is an asset we add it to the gross profit