Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please complete the attached PWC Analysis for Restaurant Co. The spreadsheet is attached along with the necessary financial information. RESTAURANT CO. PROFIT & LOSS STATEMENT
Please complete the attached PWC Analysis for Restaurant Co. The spreadsheet is attached along with the necessary financial information.
RESTAURANT CO. PROFIT \& LOSS STATEMENT RESTAURANT CO. Week 4 PWC Analysis Name: Part I: THE OPERATING CYCLE Year 1 Year 2 Insert answers in the Blue Shaded areas. \begin{tabular}{l|l|l|l|} \hline Days Receivables & Formula & Days AR = AR/Sales 360 \\ \hline + Days Inventory & Formula & Days INV = Inv/COGS 360 & \\ \hline - Days Payable & Formula & Days AP = AP/COGS 360 & \\ \hline - Days Accrual & Formula & Days ACC = ACC/COGS 360 & \\ \hline= Operating Cycle (in days) & & & \\ \hline \end{tabular} Part II: PERMANENT WORKING CAPITAL Accounts Receivable Get \$ Figure from Financial Statements + Inventory Get \$ Figure from Financial Statements - Accounts Payable Get \$ Figure from Financial Statements - Accruals Get \$ Figure from Financial Statements =PWC($s) PWC (Difference between two years) Gross Funds Flow (PAT +Depr.) - PWC = Operating Cash Flow (GFF PWC) PART III: ANALYSIS 1. Is the company using too much cash in receivables and inventory? Yes or No 2. Is the company getting too much cash from payables and accruals - In other words, are there unhappy creditors? Yes or No 3. Is GFF(PAT + non-cash expenses) sufficient to purchase new PWC each year? Yes or No - If not, we have to analyze the cash flow statement to determine the other sources of cash which are financing the increase in PWC. Triangle's Standards: Days Receivable Days Inventory Days Payable Days Accrual Days in Cycle \begin{tabular}{r|} \hline 45 days \\ \hline 0 days \\ \hline 30 days \\ \hline 15 days \\ \hline 0 days \\ \hline \end{tabular}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