Explore BrainMass

Explore BrainMass

    Cash Budgeting and Financial Forecasting

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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 October 2, 2020, 4:17 am 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.