Please help with the balance sheet

Home Insert Page Layout Formulas Data Review View Calibri (Body) -| | 11-1 A- Av Wrap Text Copy Paste A | | | Merge & Carter Office Update To keop up-to-date with security updates, fixes, and improvements, choose Cheak for Updates The company could is sue $3,000,000 of long-term bonds, due in 8 years with a stated rate of interest, pald 5 semiannually, of 4%. The market rate for slmilar debt is 6%. Cash Received $2,623,167 Annual Cash Required $32,949.601 53,000,000 4% Face amount Face rate interest Payment periods Interest Payment 12 13 $60,000.00 15 16 17 16 Market rate PV factors used 0.623 singe sum annuity 19 20 21 PV face PVinterest $1,869,000.000 $753,660.000 23 The company could issue $2,500,000 of long-term bonds, due in 7 years with a stated rate of interest, paid semiannually, of 6%. The market rate for similar debt is 4%. Cash Received $2.802,656 Annual Cash Required 29 Face amount Face rate nterest Payment periods Interest Payment Term 60% 2 a year 32 50000 7 years 35 Market rate PV factors used singesum nnuity Pvface PV interest 12.106 $18,925,000.00 9,079,500.00 Project Information potb Asset aquisitions planneddep'n NoahGodlewskiProject3part2.xls Home Insert Page Layout Formulas Data Review View cut !!Calibri ( S Wrap Text Gen Calibri (Body) 11 A-A Copy Paste Format B I Omce Update To keep up-to-date with security updates, fxes, and improvements, choose Check for Updates Partial Balance Sheet The company could issue $3,000,000 of long-term bonds, due in 8 years with a stated rate of interest paid semlanmaly. of 4%. The market rate for sinilar debt is 6%. 12 20 The company could issue $2,500,000 of long-term bonds, due in 7 years with a stated rate of interest paid semiannualy, of 6%. The market rate for similar debt is 4%. peto dep'n inancing options pt 2 finand NoahGodlewskiProject3part2.xls Insert Page Layout FormulasData Review View Cut Copy Format Home Arial ) Wrap Text Merge & Center$ Paste Office Updato To keep up-to-date with security updates,fices, and improvements, choose Check for Updates A21 : v/ Short Term Note Payable KTZFKG Consuling and Sales Ine Post Closing Trial Balance June 30,2021 198,600 75,580 5 Cash 6 Accounts Receivable 7 Allowance for Uncollectible Accounts 8 Supplies 9 Inventory 10 Prepaid Insurance 11 Land 12 Building 13 Accumulated Depr- Building 14 Oice Equipment 15 Accumulated Depr-Office Equip 16 Computer Equipment 17 Accumulated Depr-Computer Equip 18 Accounts Payable 19 Uslises Payable 4,690 56,500 58,596 57,890 160,000 459,600 19,356 785,600 45,600 1,379,160 debt 1,349,500 equity 978,500 32,560 56,560 16,850 22 Long term Note Payable 23 Mortgage Payable 24 Common Stock ($1 par, 1,000,000, 25 shares authorized, 500,000 issued 26 and outstanding) 27 Retained Eamings 28 29 30 490,000 506,800 500,000 849,500 2,830,866 $ 2830866 37 Project Information Asset aquisitions planned dep'n financing options pt 2