CourseLover

(12)

$10/per page/Negotiable

About CourseLover

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Algebra,Applied Sciences See all
Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Engineering,Health & Medical,HR Management,Law,Marketing,Math,Physics,Psychology,Programming,Science Hide all
Teaching Since: May 2017
Last Sign in: 287 Weeks Ago
Questions Answered: 27237
Tutorials Posted: 27372

Education

  • MCS,MBA(IT), Pursuing PHD
    Devry University
    Sep-2004 - Aug-2010

Experience

  • Assistant Financial Analyst
    NatSteel Holdings Pte Ltd
    Aug-2007 - Jul-2017

Category > Accounting Posted 14 Dec 2017 My Price 10.00

Prepare a comprehensive cash budget

Case study #2
Criteria:

Due date: Sunday 2/28
One Excel file submitted.
Individual work. All students are expected to prepare this case individually. File sharing on this assignment is not acceptable.

All calculations completed using Excel formula functions
Prepare a comprehensive cash budget: Case Case 2 6100 Cash budget MgAcCam.pdf
Use the format as your guide: Cash budget set up.pdf
Check figures: Cash receipts (collections) balance Aug: $20,500; Cash disbursements (all expenses) July $20,400
In addition to the preparation of the three month cash budget, provide the following descriptive analysis by addressing each of the following items fully:
Does the cash budget based on the given parameters provide the firm with the liquidity in needs in meeting operations for the quarter (and why)?
The CFO wants to know what is the impact of increasing the minimum monthly balance to $7,000. Provide a short but detailed response to the CFO on the impact of this change. Or course the CFO will expect to see the numerical values that support the response.
What is the impact of interest rate changes on the a) the budget as proposed, and b) the CFOs request for higher minimum cash balance?

Attachments:

Answers

CourseLover
(12)
Status NEW Posted 14 Dec 2017 03:12 PM My Price 10.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------usi-----------ng -----------our----------- we-----------bsi-----------te -----------and----------- ac-----------qui-----------sit-----------ion----------- of----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------ns.----------- Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m o-----------nli-----------ne -----------or -----------inb-----------ox -----------me -----------a m-----------ess-----------age-----------

Not Rated(0)