Malik’s monthly financial forecast

Please use the attached excel sheet and answer the following questions

1. 1.Examine Malik’s monthly financial forecast. Why do Guna’s financial requirements vary across the year? What are the key determinants ofGuna’s borrowing needs?
2. 2.On the basis of Malik’s forecast, how much debt will Guna need to arrange for the coming year? Will Guna be able to zero out the line of credit this year? If not, what is the cause of Guna’s ongoing need for debt?
3. 3.Use your intuition to assess the desirability of the two proposals. Do you expect these proposals to relieve or worsen Guna’s ability to clean up its bank loan? What other alternatives should Malik consider?
4. 4.Using the monthly forecast, model the impact of the proposal from the transportation manager. How helpful is this policy in relieving Guna’sreliance on debt funding? How would you assess the costs and benefits of this policy?
5. 5.Using the monthly forecast, model the impact of the proposal from the operations manager. How helpful is level production in relieving Guna’sreliance on debt funding? How would you assess the costs and benefits of this policy? As part of your assessment, consider the impact on ROA, calculated as annual Net Profit divided by average Total Assets.
6. 6.What are your recommendations for Kumar?

The post Malik’s monthly financial forecast appeared first on My Assignment Online.

Expert Help With This Assignment — On Your Terms