Construct a pro forma balance sheet based on the company's sustainable growth rate. Only assume that costs, accounts payable, and assets grow proportional to sales.

Display all answers along with the Excel formula in the sheet. This problem has to be completed in Excel so please display the answers in the sheet.

CurrentYearSalesTotalCosts(COGS&Admin.)Commonstock&Paid-inCapitalRetainedearningsDividendsPaidAccountspayableNotespayableLong-termdebtNetincomeCashAccountsreceivableInventoryNetplantandequipmentTaxrate71,00055,0006,000200,0004,2002,6005,70028,00012,6403,1404,2006,500150,00021% HEIR JORDAN CORPORATION Pro Forma Balance Sheet CurrentYearSalesTotalCosts(COGS&Admin.)Commonstock&Paid-inCapitalRetainedearningsDividendsPaidAccountspayableNotespayableLong-termdebtNetincomeCashAccountsreceivableInventoryNetplantandequipmentTaxrate71,00055,0006,000200,0004,2002,6005,70028,00012,6403,1404,2006,500150,00021% HEIR JORDAN CORPORATION Pro Forma Balance Sheet