Financial Planning and Analysis
Essay Preview: Financial Planning and Analysis
Report this essay
Financial Analysis
20X1
20X2
20X3
20X4
20X5
Return on Sales
(Net Profit Margin)
0.028
0.028
0.028
0.028
Return on Equity
0.083
0.143
0.222
0.308
0.381
Average Collection Period
(Days Sales Outstanding)
Inventory Turnover
Current Ratio
3.333
1.542
Quick Ratio
1.333
0.542
0.459
0.434
Debt to Equity
0.714
1.889
2.769
Fixed Asset Turnover
9.931
11.755
16.696
Financial Planning and Analysis
Based on the information provided for year 20X1 to 20X4, the trend and patterns arise as follow: the cash and miscellaneous assets were consistent, the account receivable and inventory doubled every year. The fixed assets increased by 1 million from year 20X3 to year 20X4 thus i estimate that it will also increase by 1 million in the following year 20X5. This is quite reasonable since the total assets increased around 46% to 62% between 20X1 and 20X4. The total assets of $18,000,000 in year 20X5 is a 54% increase from previous year which is exactly between that range thus the figure can be consider valid.
The notes payable from year 20X3 to 20X4 has also been consistent so I estimate that year 20X5 note payable will be $900,000 just like previous two years. The account payable forecast is $10,800,000 which is approximately 44% increase from previous year. The increase in account payable every year is due to the growth of the company; this short-term debt payments to the banks and supplies is a result mainly from the excess in inventory, which doubled every year, and the fixed assets. The long-term debt is predict to be increase by 70% which is necessary for the companys expansion to cover up all the expense on fixed assets or inventory for example.
The difference in net worth each year doubles by 2, therefore in year 20X5 the net worth is estimate to be $4,200,000. However, in percentage, it is a continuous decline in net worth every year (86% to 62%) which can mean two things: 1.) The existing shareholders are not reinvesting enough or the company need to issue more stocks to the public 2.) Although the return on equity has been increasing every year which mean that the company had generated high returns relative to their shareholders equity; however, the question arises to why didnt the net worth increase when the return on equity ratio is very preferable to shareholders or investors. This might be due to other factors such as how investors assess