Explore BrainMass

Cash Budgeting and Financial Forecasting

Please address the 17 questions in the case study review and evaluate the case, identifying the decisions to be made pertaining to financial forecasting.

Determine quantitative and qualitative factors pertaining to financial forecasting.

Conclude findings pertaining to a financial forecasting case and provide recommendations for the case at hand.

© BrainMass Inc. brainmass.com August 18, 2018, 1:43 pm ad1c9bdddf


Solution Preview

If we look at the cash surplus and loan requirement data we can find that the maximum monthly cash shortfall of $60,750, occurs in the month of June and the maximum funds that the clinic require is $99,000 occurs in the month of February. We can find net projected cash gains in the month of March, April, and May, and the cumulative gain of these months is sufficient to retire the loan during the month of April. But a net cash loss is forecasted for the month of June means that an extension of the budget is required for the entire year.

Please look at the excel sheet for the data.
We have,

Monthly interest on line of credit=0.667%


Monthly Interest on temporary investment of excess cash=0.333%

Cash at beginning=$50,000

January February March April May June
Surplus Cash or total loan outstanding -$48,417 -$98,844 -$23,686 $1,43,847 $1,69,493 $1,08,178

As we know that the clinic has $50,000 balance at ...

Solution Summary

The expert examines cash budgeting and financial forecasting. Quantitative and qualitative factors pertaining to financial forecasting is examined.