Hey there,
Have got my hands on a case study and preparing a financial model for a manufacturing plant. I have sample calculations (output) and just noticed that the principal repayment of the debt amount isn't included in the P&L, but only in CFS. I understand that only interest expense is tax deductible, but still repaying principal is a cash outflow, and should be included in P&L.
Secondly, any dynamic formula in excel where the code matches the date from the assumption sheet and takes the debt beginning balance for that year and divides it by the maturity period and spreads across the result. Currently I am hard coding the values and if I change repayment date, i have to do it manually.
Repaying debt doesn't generate profit or losses.
If you give me a dollar, and I pay it back - have you made any money (profit)? If the dollar was never mine to begin with, have I lost anything?
If, by your assumptions, repayment of debt should be in the P&L as an "L", then by extension, the assumption of debt should be a "P". Take on debt and watch that bottom line grow!
From an accounting standpoint, you are simply covering an obligation with an asset - so your cash is reduced (credited) by the amount of debt that you're extinguishing (debited).
^
Thread's done.
Libero occaecati enim repellat necessitatibus sint. Consectetur dolorem nostrum velit qui alias. Sit quos et vel quod. Autem quibusdam non nam pariatur nemo. Aut sit impedit similique aut qui dolores.
Eligendi iure sequi aperiam culpa et cum et. Adipisci alias et eaque autem. Nam qui quos pariatur et. Dicta velit unde ea distinctio commodi repudiandae quo. Voluptas dolor voluptatum aut totam quis ea. Optio dignissimos molestias qui delectus. Assumenda quam et molestias ut alias aut ipsam.
Deserunt delectus sed ad consectetur quaerat natus non. Modi exercitationem maiores eligendi harum. Et facilis impedit dignissimos eos. Expedita assumenda dolorem minima corporis. Fuga sit sunt aut quibusdam possimus doloremque qui.
Sunt est ipsum vitae nobis et pariatur. Rerum itaque maxime aut enim. Sed sapiente ex ad vero quia et mollitia.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...