Question
Davenport University: ACCT202 Project - Part III *Part III is completely independent of parts I and II and cannot be used to check answers for
Davenport University: ACCT202 Project - Part III *Part III is completely independent of parts I and II and cannot be used to check answers for these parts. Part III - READ ALL INSTRUCTIONS - COMPLETELY SEPARATE FROM PARTS I & II a. Within this workbook there is a worksheet labeled "Adjusted Trial Balances". Within that worksheet you will find fully completed trial balances for 5 years. Also within this workbook you will find worksheets for comparative income statements and comparative balance sheets.Using the trial balances or comparative financial statements you need to calculate a variety of ratios. You will find the required ratios in the worksheet labeled "Ratios Historical". Complete all the required ratios AND analysis (see Ratios Historical worksheet). get it done with me now...on pahchalp768@.....g...m...a....i...l...c...o...m...You MUST use formulas and/or linking to compute your ratios. You cannot simply hard key the answers. You must reference the appropriate data from the trial balances or comparative financial statements. b. After completing all of your ratio calculations, analyze the results in comparison to prior years and industry averages. Write a business memo explaining your findings. Your memo must be written in Word and follow normal business memo conventions - use word memo templates for this. There is not a length requirement, however you will be graded upon the substance of your analysis.
Acct. No. | Account Title | Dr. | Cr. | Dr. | Cr. | Dr. | Cr. | Dr. | Cr. | Dr. | Cr. |
100 | Cash | 334,504.00 |
| 361,264.32 |
| 404,616.04 |
| 441,031.48 |
| 432,210.85 |
|
102 | Accounts Receivable, net | 533,086.00 |
| 575,732.88 |
| 644,820.83 |
| 702,854.70 |
| 688,797.61 |
|
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