Question
Hello dear, I have Excel sheet. But I couldn't find how to upload it. So I am waiting for your reply so I can upload
Hello dear, I have Excel sheet. But I couldn't find how to upload it. So I am waiting for your reply so I can upload working Excel file.
This is an individual assignment. You will find specific instructions in the attached Module 1 Excel Workbook. You will submit your work in one (1) Excel file when you have finished all three parts of this assignment.
Note that you can complete each part of this assignment separately, and no part of the assignment is dependent on the others. In other words, part (A) is not related to part (B), etc.
The first worksheet tab named A. Statements of Cash Flow contains three company scenarios listed down the left side of the worksheet. Based on the information provided in each scenario, prepare the corresponding Statement of Cash Flows in the columns to the right of each scenario. Your Statement of Cash Flows should utilize cell referencing and formulas where applicable. (30 points-- graded for accuracy and format).
The second worksheet tab named B. Cash T-Accounts contains two company scenarios listed down the left side of the worksheet. Based on the information provided in the scenarios, complete the corresponding Cash T-Account for each company in the columns to the right of each scenario. Your T-Accounts should utilize cell referencing and formulas where applicable. (20 points--graded for accuracy and format).
The third worksheet tab named C. Cash Flow Analysis contains two company scenarios listed down the left side of the worksheet. Based on the information provided in the scenarios, calculate the Cash Coverage of Growth ratio and the Free Cash Flows for each company and respond to the questions asked. Include the written ratio formulas in addition to listing all numbers used in your calculations to show your work. Put all formulas and calculations in the columns to the right of each scenario. Your ratios and calculations should utilize cell referencing and formulas where applicable. (26 pointsgraded for accuracy and format).
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started