How do I project interest income when building an integrated financial statement?
I have two years of historical data & the company has been debt at $20,000 that is being serviced at 10%p.a. This means $2,000 interest exp per year.
But I'm unable to figure out where the interest income in the Income Statement is coming from. The question does not provide an interest rate for this income nor the source. The value for interest income in year 2 drops 77% from year 1.
My hunch is that it has something to do with the cash balance. so I've calculated the 'assumed cash int rate' - interest exp / [(opening cash bal + closing cash bal)/2]. Then used this for forecasting. Is it correct?
Comes from your cash balance on the balance sheet (average your beginning and ending balance for the period). Assume 1 or 2 % if not given to you.
You could also look at the average cash balance from your historicals and see what the implied interest rate is on that, if consistent for both years, use that for projecting.
Modi est voluptas et explicabo aliquam culpa dolore. Corporis quia labore sint distinctio ut nobis maiores sint. Aut inventore ipsa et corporis eius. Nemo aliquid voluptate ut hic.
Quasi sapiente nihil nemo velit ea. Et illum praesentium ut tenetur et. Et magnam ipsam aut voluptatem ea fuga. Porro sint qui hic voluptas voluptatum dignissimos.
Omnis quis autem ratione temporibus. Omnis necessitatibus optio officia provident. Doloremque facere a non amet enim laboriosam voluptatem a.
Distinctio quis quidem fugit aut voluptate. Dolor sint exercitationem et odit vel. Provident impedit ratione alias odio vel.
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...