Within 2 hours
- or -
Post a project like this2063
$20
- Posted:
- Proposals: 4
- Remote
- #2110570
- Awarded
Description
Experience Level: Intermediate
Estimated project duration: 1 day or less
I've got a problem with the cash forecast for a company and prepare the revenue/cash forecast report in Excel sheet.
ABC Inc is the manufacturer of a type of industrial components moderately popular with the coolants and air compressors industry. ABC Inc’s accountants have identified an urgent need for a swift improvement in cash flow, to keep the business afloat.
You have been asked to help the team forecast cash flow for the coming three years with particular focus on the next twelve months. Use the following information to draft a three-year monthly cash flow forecast with the first month being October 2013 and use it to answer the following key questions.
Recognizing the upcoming cash shortfall, the board orders a review of your sales terms. Based on the analysis, if the following strategy were to be adopted from 1 January onward, what would the cash balance be closest to at the end of the calendar year 2015?
• sale price increases by 12%
• forecast volume is lower going forward by 5%
• direct cost per unit is maintained.
ABC Inc is the manufacturer of a type of industrial components moderately popular with the coolants and air compressors industry. ABC Inc’s accountants have identified an urgent need for a swift improvement in cash flow, to keep the business afloat.
You have been asked to help the team forecast cash flow for the coming three years with particular focus on the next twelve months. Use the following information to draft a three-year monthly cash flow forecast with the first month being October 2013 and use it to answer the following key questions.
Recognizing the upcoming cash shortfall, the board orders a review of your sales terms. Based on the analysis, if the following strategy were to be adopted from 1 January onward, what would the cash balance be closest to at the end of the calendar year 2015?
• sale price increases by 12%
• forecast volume is lower going forward by 5%
• direct cost per unit is maintained.
Suresh M.
100% (1)Projects Completed
1
Freelancers worked with
1
Projects awarded
100%
Last project
17 Aug 2018
India
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies