How to calculate days cash on hand for 2017 and 2018 (based on information in wo
ID: 2584378 • Letter: H
Question
How to calculate days cash on hand for 2017 and 2018 (based on information in workbook sheets 1 and 2)? Week 13 Excel,Workbook.als (Compatibility Mode] Excel Home Insert Page Layout Formulas Dats Review ViewPDF 9 Tell me what you want to deo -110 .ka":. Arial Wrap Tat Formatting T Cipboard Font Number | i | x 2A. Common Size Balance SheeticarA. Common Size Balance Sheetial v A 4 2 017 2016 3 Part B 5 Current Ratio 6 10 11 Part C 12 13 Days Cash 14 on Hand 15 16 17 18 Part D 19 20 Debt to Equity 21 24 25 26 27 Part E 28 29 Total Margin 30 32 6 Part 37 A. Com. Sice Activity Statement Ratios Parts 8 to G
Explanation / Answer
Solution:-
How to calculate days cash on hand for 2017 and 2018 :-
The formula is: = Cash on hand ÷ ((Operating expenses - Noncash expenses) ÷ 365)
= 1,909,606 ÷ ((6,318,885) ÷ 365)
= 110 Days
= 1,044,193 ÷ ((34,998,051) ÷ 365)
= 11 Days
Please Rate or comment if you have any doubt regarding this solution.
Related Questions
Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.