Prepare Income and Cash Flow Statement
Not what you're looking for?
Prepare an Income AND a Cash Flow Statement for the following:
Data Block
Investments Quanty Unit Price Total Working Capital Loan
Batteries 100 $5,000 $500,000 Year Intrest Bal
Chargers 25 $2,500 $62,500 $500,000
Transfer Machines 5 $75,000 $375,000 1 $35,000 $535,000
Total $937,500 2 $37,450 $572,450
3 $40,072 $612,522
Capital investment $937,500 4 $42,877 $655,398
Variable Cost 70% Of revenue 5 $45,878 $701,276
Land cost/Yr $50,000
Admin Cost/Yr $150,000 Rate 7.00%
Marketing/Yr $35,000
Refurbish cost/Yr $100,000 starting in year 2
Working Capital $500,000 Intrest only @ 7% annually
Salvage value $1,000,000 After 5 years
Tax rate 35%
Corp. Admin/Yr $600,000
Year 0 1 2 3 4 5
Revenue $3,000,000 $3,900,000 $4,680,000 $5,148,000 $5,405,400
Revenue growth % 30.00% 20.00% 10.00% 5.00%
Depreciation 20.00% 32.00% 19.20% 11.52% 11.52% 5.76%
Variable cost $2,100,000 $2,730,000 $3,276,000 $3,603,600 $3,783,780
Purchase this Solution
Solution Summary
The expert prepares an income and cash flow statements.
Education
- Chartered Accountant (Equivalent to CPA in US), Institute of Charted Accountants of India
- Bachelor of Commerce, West Bengal University
Recent Feedback
- "I got this feedback and I wanted to know if you can explain it to me. I noticed something within your workings which I believe is incorrect. It looks like you've mistaken the Debt ratio for the Equity Multiplier. You've done a calculation to determine Return on Equity (ROE) but if you take a look at the ratios provided for us you'll see ROE listed on the bottom line already. You can use ROE, Profit Margin and Total Asset Turnover to figure out the Equity Multiplier amount. Equity multiplier is not provided for us and we need to calculate it. I really hope this is helpful to you. "
- "Very attentive to detail. Answers are designed in easy to understand format."
- "Fast response and thorough answer"
- "thank you very much! "
- "thank you so much !!!!!!!"
Purchase this Solution
Free BrainMass Quizzes
Understanding Management
This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.
Income Streams
In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.
Situational Leadership
This quiz will help you better understand Situational Leadership and its theories.
Motivation
This tests some key elements of major motivation theories.
Paradigms and Frameworks of Management Research
This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.