Argo's forecast balance sheet has been included in the Excel file, so you need do nothing to it. However, the CFO has asked you to consolidate the two balance sheets - the Argo one given to you and the SkyBlue one that you calculated. Once these two are consolidated, you are asked to calculate three debt ratios, as listed in the file.

Balance Sheet Cash Notes and Acc. Rec. Inventory Prepaid Current Assets Other Total Assets Actual 2020 240 7,013 5,588 192 13,033 3,325 16,358 Projected 2021 2022 2023 Notes 250 250 250 8,385 9,998 12,040 6,630 7,905 9,520 195 232 280 15,460 18,385 22,090 3,830 4,393 5,105 19,290 22,778 27,195 Bank Loan Payables CPLTD Other Current Liabilities LTD 600 3,057 433 1,477 5,567 2,458 656 3,705 450 1,712 6,523 2,008 657 4,417 450 1,994 7,518 1,558 680 5,320 450 2,350 8,800 1,108 Equity Total Liabilities & Equity 8,333 16,358 10,759 13,702 17,287 19,290 22,778 27,195 0.1 0.1 Ratios: Bank Loan to Receivables Liabilities / Equity Debt / Equity 1.0 0.4 0.8 0.3 0.1 0.7 0.2 0.1 0.6 0.1