Explore BrainMass

Implication of different variables on additional funds

I need assistance in describing results of the attached pro forma statement and making recommendations to management based on these results. Need this in a summarized form. No need for spreadsheet work....Just a couple of paragraphs would be okay.

Some assumptions used in compliling the attached pro-forma are.

-Assets as a % of sales in FYE 04 was 88%. Liabilities available for spontaneous funding as a % of sales - 19.9%.

-In the past, dividends have been paid and the percentage (based on net income) was 37.6%, the same level of dividends was assumed for FYE05 results.

- An increase in sales of 20% resulted in revenue for FYE 05 of $24,023.

-Sales has increased, therefore, the level of retained earnings and the support provided by the spontaneous liabilities analyzed, the funding shortfall is $475.

Added underlying assumption document...
When an organization forecasts financial information it is using pro forma financial statements. The first financial statement is the income statement that is developed, then the cash budget and finally the pro forma balance sheet is developed. When developing these pro forma financial statements there are certain assumptions used. There is an assumption, or plan for increased sales and then inventory needs to be determined based on this projection. When the pro forma income statement was developed for ACME has assumed that the cost of goods sold, expenses, interest, taxes, and dividends remained at the same percentage level. For this scenario it is assumed that at times of increase sales that the rest of the expenses do increase at the same rate. On the income statement, not only did sales rise by twenty percent but all of the expenses were raised twenty percent as well. For this scenario it is assumed that these percentage levels will remain the same with the understanding that the pro forma financial information can be modified as it is analyzed over time. The balance sheet can now be developed off of the pro forma income statement, prior balance sheet and the cash budget, which is not used in this scenario.


Solution Preview

Implication of different variables on additional funds needed

Higher sales has put pressure on AFN, It will lead to increases in asset requirements and will increase AFN. Moreover dividend payout ratio is at same level that is 37.5%ratio, it has also put pressure on the need of funds. In ...

Solution Summary

This explains the implication of different variables on additional funds needed