Complete the attached spreadsheet for Triangle Co at the bottom. You will only complete the Year 2 column since you only have financials for Years 1 and 2. Please Help!! This is all I have.

TO COMPUTE LINE 79 ON THE CASH FLOW STATEMENT: + Ending Net Fixed Assets (Year 2) + Depreciation/Amort Expense (Year 2) - Beginning Net Fixed Assets (Year 1) = Net Capital Expenditures (Sell Fixed Assets if negative) TO COMPUTE LINE 86 ON THE CASH FLOW STATEMENT: + Ending Net Worth (Year 2) - PAT (on Profit & Loss Year 2) - Beginning Net Worth (Year 1) = New Equity (Distributions if negative) TO COMPUTE LINE 81 ON THE CASH FLOW STATEMENT: Use the Prepaid line on the Balance Sheet for the Increase in Other Current Assets.

Notes for the the empty spreadsheet below!

TRIANGI F C.O TRIANGLE CO. PROFIT \& LOSS STATEMEN isert answers in the Blue Shade A market study was completed for a retail operation. The market study and RMA indicates: (Show all of your work) - What is the operating cycle (in days)? Choose the correct formula Operating Cycle =40+90=130 days Net Operating Cycle =1304010=80 days - What is the A/R at the end of the year (\$'s)? Choose the correct formula A/RX365/1,000=40 1000X40/365=$109.59 - What is the Inventory at the end of the year (\$'s)? Choose the correct formula Inventory X 365/600=90 Inventory =600X90/365=$147.95 - What is the Accounts Payable at the end of the year (\$'s)? Choose the correct formula 4 Accounts payable 365/600=40 =600X40/365=$65.75 - What is the Accruals at the end of the year (\$'s)? Choose the correct formula Accrued expenses X 365/1000 =10 =1000X10/365=$27.40 - What is the investment in PWC (\$'s)? Choose the formula-you will be using the answers from above. Current assets A/R+ Inventory 109.59+147.95=257.54 Current liabilities AP+AE65.75+27.40=93.15 PWC 177 TRIANGI F C.O TRIANGLE CO. PROFIT \& LOSS STATEMEN isert answers in the Blue Shade A market study was completed for a retail operation. The market study and RMA indicates: (Show all of your work) - What is the operating cycle (in days)? Choose the correct formula Operating Cycle =40+90=130 days Net Operating Cycle =1304010=80 days - What is the A/R at the end of the year (\$'s)? Choose the correct formula A/RX365/1,000=40 1000X40/365=$109.59 - What is the Inventory at the end of the year (\$'s)? Choose the correct formula Inventory X 365/600=90 Inventory =600X90/365=$147.95 - What is the Accounts Payable at the end of the year (\$'s)? Choose the correct formula 4 Accounts payable 365/600=40 =600X40/365=$65.75 - What is the Accruals at the end of the year (\$'s)? Choose the correct formula Accrued expenses X 365/1000 =10 =1000X10/365=$27.40 - What is the investment in PWC (\$'s)? Choose the formula-you will be using the answers from above. Current assets A/R+ Inventory 109.59+147.95=257.54 Current liabilities AP+AE65.75+27.40=93.15 PWC 177