Creating a spread sheet for one year's cash flow
Not what you're looking for?
Fluffy Bunnies makes cuddly toys for sale in the USA. All costs and income is in dollars.
The company makes 2,000 toys for sale in each month and sells them all for cash payments (no credit sales). Each bunny sells for $6.25 including VAT. Variable costs per item are $3.50 including VAT. Variable costs are paid as they are incurred. Fixed costs are $12,000 per annum including VAT on all these costs. VAT is paid every three months in the month following the end of the calendar quarter.
Wage costs are $2,500 per month on which 22% withholding taxes are deducted and paid twice a year in the month following the half year close.
VAT is 12.5%.
Ignore all other taxes.
1 Create a spread sheet for one year's cash flow giving monthly balances and starting with a cash balance of $10,000.
2 Do you run out of money?
3 What would an investor say if you asked for investment based on this cash flow?
Purchase this Solution
Solution Summary
The expert creates a spread sheet for one year's cash flow.
Solution Preview
Please see the attachments.
Fluffy Bunnies makes cuddly toys for sale in the USA. All costs and income is in dollars. The company makes 2,000 toys for sale in each month and sells them all for cash payments (no credit sales). Each bunny sells for $6.25 including VAT. Variable costs per item are $3.50 including VAT. Variable costs are paid as they are incurred. Fixed costs are $12,000 per annum including VAT on all these costs. VAT is paid every three months in the month ...
Education
- B. Sc., University of Nigeria
- M. Sc., London South Bank University
Recent Feedback
- "Thank you."
- "thank you Chidi Ngene.. if you have any APA references would be great"
- "Thank you so much for your help, your explanations were easy to understand and apply!"
- "are you able to highlight the equations used either on the xlsx or a word doc as to how each graph was formed- overall looks fine i just need help understanding this myself"
- "Chidi Ngene, M. Sc. Was extremely helpful as without the help and guidance I would have failed, but with the help I passed. I still have a lot to learn and in need of the guidance to understand and learn more on the subject. I would recommend Chidi Ngene and BrainMass to anyone that are in need of help. Thank you!!"
Purchase this Solution
Free BrainMass Quizzes
Change and Resistance within Organizations
This quiz intended to help students understand change and resistance in organizations
Marketing Research and Forecasting
The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.
Motivation
This tests some key elements of major motivation theories.
Managing the Older Worker
This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce
Organizational Leadership Quiz
This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.