Overview
Part A
There are two components to this assignment:
Part 1:
Complete the statement of cash flows using the information provided in the Alpha Company's Income statement and comparative balance sheets template Download Alpha Company's Income statement and comparative balance sheets template. Use Excel formulas within the cells to calculate all required calculated numbers.
Part 2:
Prepare a well-structured paper that addresses the following:
- Purpose of the Statement of Cash Flows
- Explain the role of the statement of cash flows in financial reporting.
- Discuss how it complements the balance sheet and income statement in assessing a company’s financial health.
- Preparation of the Statement of Cash Flows
- Describe the process of preparing a statement of cash flows.
- Use examples from Part 1 of this assignment to illustrate key components, including operating, investing, and financing activities.
- Key Insights from the Statement of Cash Flows
- Identify important information that can be derived from the statement of cash flows.
- Discuss how investors, creditors, and managers use this statement to evaluate a company’s cash position, liquidity, and overall financial performance.
Your paper should be clear, concise, and well-organized. Support your explanations with examples and references where appropriate.
Citations must be presented in APA; however, the formatting of the paper in APA will not be required.
Your paper should be 3 to 5 pages in length and conform to APA guidelines. Include at least three credible references in addition to the course textbook. The CSU Global Library is a good place to find these references.
Part B
This assignment consists of two parts:
Part 1: Financial Ratio Analysis
- Select two publicly traded companies that operate within the same industry (e.g., Apple vs. Microsoft, Coca-Cola vs. Pepsi, Starbucks vs. Dunkin').
- Perform a ratio analysis for each company by calculating at least two ratios from each of the following categories:
- Profitability Ratios (e.g., Net Profit Margin, Return on Assets)
- Liquidity Ratios (e.g., Current Ratio, Quick Ratio)
- Leverage Ratios (e.g., Debt-to-Equity Ratio, Interest Coverage Ratio)
Ensure your calculations are accurate and properly labeled in two tabs in an Excel workbook.
Include links to the financial statements used for your analysis.
Part 2: Investment Recommendation Paper
Using the ratio analysis from Part 1, write an argument paper persuading investors to choose one company over the other. Your paper should include:
- Introduction: Briefly introduce the two companies and the purpose of the analysis.
- Thesis Statement: Clearly state which company is the better investment choice and why.
- Analysis and Justification: Compare the ratios, highlighting key strengths and weaknesses. Support your argument with financial insights.
- Conclusion: Summarize your findings and reinforce your investment recommendation.
Deliverables:
- Excel Workbook
- Properly labeled and calculated ratios
- Links to the financial statements of the selected companies
Word Document (Argument Paper)
- Well-structured analysis with clear reasoning and supporting evidence
Your paper should be three to five pages in length and conform to APA guidelines. Include at least three credible references in addition to the course textbook. The CSU Global Library is a good place to find these references.
Part C
This assignment is part of the Green Harvest case. Review the following resources to prepare for the assignment:
- Green Harvest Master DocumentDownload Green Harvest Master Document
Instructions
There are two components to this assignment.
Capital Investment Analysis: Green Harvest
Scenario: Green Harvest is considering an investment in new technology to remain competitive. The company is evaluating the purchase of a new piece of equipment with the following details:
- Initial Investment Cost: $2,800,000
- Expected Annual Net Cash Inflows: $420,000
- Project Duration: 10 years
- Discount Rate: 7%
Required Calculations:
Using the provided Excel template Download Excel template, calculate the following financial metrics for the proposed equipment purchase:
- Net Present Value (NPV) – Use the discount rate of 7% to determine the present value of future cash inflows and assess whether the investment generates a positive return.
- Internal Rate of Return (IRR) – Calculate the discount rate at which the project’s NPV equals zero.
- Payback Period – Determine how many years it will take for the initial investment to be recovered through net cash inflows.
Part 1:
Complete the calculations for analyzing the proposed equipment purchase in the provided Excel workbook. Use Excel formulas within the cells to calculate all required calculated numbers.
Part 2:
Prepare a professional PowerPoint presentation for management that addresses the following key areas related to the proposed equipment purchase. Your presentation should be clear, concise, and persuasive, focusing on decision-making rather than calculation details.
Slide Content Guidelines:
- Title Slide
- Presentation title
- Your name
- Date
- Introduction
- Briefly introduce the capital budgeting decision under review.
- Explain why this investment is being considered.
- Significance of Financial Calculations
- Explain the role of financial metrics such as Net Present Value (NPV), Internal Rate of Return (IRR), and Payback Period in capital budgeting.
- Emphasize why these calculations are critical in assessing the financial feasibility of the investment.
- Recommendation Based on Financial Analysis
- Summarize the results of the calculations without showing formulas.
- Clearly state whether the equipment purchase is financially justifiable based on these calculations.
- Non-Quantitative Factors to Consider
- Discuss at least three qualitative factors that could influence the decision, such as:
- Strategic Alignment: Does the investment align with long-term business goals?
- Technological Advancements: Will the equipment remain competitive over time?
- Operational Impact: How will implementation affect current operations and employees?
- Regulatory & Environmental Considerations: Are there compliance or sustainability concerns?
- Discuss at least three qualitative factors that could influence the decision, such as:
- Final Recommendation
- Provide a clear and well-supported recommendation.
- Mention any additional analysis or factors management should consider before making a final decision.
- Conclusion & Next Steps
- Summarize key takeaways.
- Suggest follow-up actions (e.g., further risk assessment, supplier negotiations).
Formatting Requirements:
- Professional, business-appropriate slide design.
- Use bullet points for clarity.
- Include visuals where appropriate (charts, graphs, relevant images).
- Keep slides concise and engaging (avoid excessive text).
Your presentation should be 8-10 slides in length with speaker notes and conform to APA guidelines. Include at least three credible references in addition to the course textbook. The CSU Global Library is a good place to find these references.
Part D complete discussion
Having a cash budget | LinkedIn Learning
After watching the video, discuss each of the steps in the budget process and incorporate an example of how your current or past employer might implement each step in it’s budget process. If you are not familiar with the cash budget process from the business perspective, use how you might develop a personal cash budget, as your example.
Be sure to post an initial, substantive response by Thursday at 11:59 p.m. MT, and respond to two or more classmates or the instructor with substantive responses by Sunday at 11:59 p.m. MT.
Part E reply to discussion
When examining the budgeting process from a business perspective, it becomes clear that cash receipts, cash payments, and financing are three essential components that determine an organization’s financial stability. Each step provides valuable insight into how a company manages its inflows, outflows, and long-term financial obligations. Cash receipts, also known as cash inflows, represent the funds a business brings in through its operations. Understanding these inflows is crucial because they determine how much cash is available to support ongoing activities or upcoming projects. By accurately forecasting cash receipts, businesses can better anticipate whether they will have sufficient resources to meet their operational needs. Cash payments, in contrast, represent cash outflows. These include necessary expenses such as taxes, equipment purchases, rent, and employee salaries. This step is vital because it highlights the ongoing financial commitments required to keep the business functioning. As Kenley (2003) notes, “It is necessary therefore to smooth the inward cash flow to remove the jagged nature of the net cash flow,” emphasizing the importance of managing both inflows and outflows to maintain financial balance. Monitoring cash payments helps organizations understand how much is being spent to cover routine operating expenses. Financing is another critical part of the budgeting process, as it involves planning for borrowing and repayment activities. By analyzing financing needs, a business can determine how to secure the funds required for growth while ensuring it remains capable of meeting its long-term obligations. Understanding how financing impacts the overall budget allows companies to remain financially stable and competitive. These same budgeting principles can also be applied to personal finance. Individuals can start by calculating their monthly income after taxes and deductions. Tracking expenses and categorizing them such as dining out, transportation, or loan payments helps create a clear picture of spending habits. Setting limits for each category, including savings goals, allows for more intentional financial planning. Finally, adjusting the budget as expenses change ensures it remains realistic and effective over time. Overall, understanding the budgeting process provides both businesses and individuals with the tools needed to make informed financial decisions. By analyzing cash inflows, outflows, and financing needs, it becomes easier to maintain stability and achieve long-term goals.
Part F reply to discussion
Budgeting as a Cost Center
In my company, I’m a cost center! This means my annual budget is pretty simple for the sources of inflows and has a lot of outflows! In fact, starting with the steps we learned about in Kennedy (2025)*, aligning with my market’s strategic plan is the foundation and starting point for building my budget and spending money efficiently and effectively is the goal.
In the Analysis and Development stages, I look at where we spent our money over the last year and how effective the expenditures or investments were. Then I decide what to keep/continue and ideate for new ways to achieve our strategic goals, then forecast the costs and timing for each of these expenditures. As a department level budget, mine rolls up to the overall corporate budget, so accurate estimates and timing of expenditures is critical for the company’s overall cash flow.
Budgeting never stops. The final steps of putting it into action, keeping track and reviewing and approving are cyclical across the year, sometimes on a weekly basis. Opportunities come and go, so the budget needs to be flexible to leverage or shift based on priorities. Inflows also can shift over the year. Often the top of house requires expense cuts at the market level to balance the budget or (less often!) a surplus is allocated to markets and we get to deploy the unexpected windfall.
I know some find budget management tedious, but I enjoy the strategy and creativity behind it. Ironically, I don’t have a personal budget which defies the logic I know well!
What is your opinion on budgeting? Tedious or engaging?