In cell I3, enter a formula that calculates the First Half Debt for General Bonds as a Percent of the Total Debt. In the formula, refer to H8 as an absolute cell reference.I just need formula to get an answer. Please see the second image for final result. File Home Insert Draw Page Layout131UndoAPasteClipboardDebt23 General Bonds4Lease Bonds5 Revenue Bonds6 Loans7 Capital Leases8 Total910 Highest Debt11 Lowest Debt12 Average Debt135GaramondB I U vX ✓ fxBFontс11Formulas Data Review ViewA^ AD5March=AlignmentHelpFECity DebtJanuaryFebruaryAprilMay$ 107,300 $ 71,930 $65,300 $ 110,561 $ 30,787 $25,830 $411,708166,26075,75072,107119,35830,29925,962489,736111,62575,25065,206111,68525,07727,605416,448153,53580,25072,008113,06572,56028,606520,024117,22089,35077,015115,69575,20630,615505,101$ 655,940 $ 392,530 $ 351,636 $ 570,364 $ 233,929 $ 138,618 $ 2,343,017CustomJune←0.00% 9 .00 →.0NumberH5IConditional FoFormatting TStyFirst Half Total Percent ofDebtTotal Debt DebtGeneral BondsLease BondsRevenue BondsLoansCapital LeasesTotalHighest DebtLowest DebtAverage DebtJanuaryAspen Falls DebtCity DebtFebruary March$ 166.260 $89,350 $71,930 $$ 107,300 $$ 131,188 $ 78,506 $April77,015 $65,206 $70,327 $MayJune$ 107,300 $ 71,930 $ 65,300 $ 110,561 $ 30,787 $ 25,830 $ 411,708166,26075,75072,107119,35830.29925,962489,736111,62575,25065,206111,68525,07727,605416,448153,53580,25072,008113,06572,56028,606520,024117,22089,35077,015115,69575,20630,615505,101$ 655,940 $ 392,530 $ 351,636 $ 570,364 $ 233,929 $ 138,618 $ 2,343,017First HalfTotal Debt119,358 $ 75,206 $ 30,615110,561 $ 25,077 $25,830114,073 $ 46,786 $ 27,724Percent ofTotalDebt17.6%20.9%17.8%22.2%21.6%

Debts are the obligations for an entity. These are just like creditors so the payment of the…

Debt General Bonds Lease Bonds Revenue Bonds Loans Capital Leases Total Highest Debt Lowest Debt Average Debt City Debt April 65,300 $ 110,561 $ 30,787 $ 72,107 119,358 30,299 65,206 111,685 25,077 72,008 113,065 72,560 117,220 77,015 115,695 75,206 $ 655,940 $ 392,530 $ 351,636 $ 570,364 $233,929 $ January $ 107,300 $ 166,260 111,625 153,535 February 71,930 $ 75,750 75,250 80,250 89,350 March May June First Half Total Percent of Debt Total Debt 25,830 $ 25,962 27,605 28,606 30,615 138,618 $ 411,708 489,736 416,448 520,024 505,101 2,343,017

Debt General Bonds Lease Bonds Revenue Bonds Loans Capital Leases Total Highest Debt Lowest Debt Average Debt City Debt April 65,300 $ 110,561 $ 30,787 $ 72,107 119,358 30,299 65,206 111,685 25,077 72,008 113,065 72,560 117,220 77,015 115,695 75,206 $ 655,940 $ 392,530 $ 351,636 $ 570,364 $233,929 $ January $ 107,300 $ 166,260 111,625 153,535 February 71,930 $ 75,750 75,250 80,250 89,350 March May June First Half Total Percent of Debt Total Debt 25,830 $ 25,962 27,605 28,606 30,615 138,618 $ 411,708 489,736 416,448 520,024 505,101 2,343,017

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

BALANCE SHEETCash $ 140.0 Accounts payable $ 800 .0Accts. receivable 880 .0 Notes payable 600.0Inventories 1,320.0 Accruals 400 .0Total current assets $2,340.0 Total current liabilities $1,800.0Long-term bonds 1,000.0Total debt $2,800.0Common stock 200 .0Retained earnings 1,000.0Net plant & equip. 1,660.0 Total common equity $1,200.0Total assets $4.000.0 Total liabilities & equity $4.000.0lNCOME STATEMENTNet sales $6,000.0Operating costs 5,599.8Depreciation 100.2EBIT $ 300.0Less: Interest 96 .0EBT $ 204 .0Less: Taxes 81.6Net income $ 122.4OTHER DATAAnnual Principal and Lease Payments 0.00Shares outstanding (millions) 60 .00Common dividends (millions) $42.8Interest rate on NIP and long-term bonds 6.0 %Federal plus state income tax rate 40%Year-end stock price $30 .60 Question 9 What is the firm's Debt Ratio? Group of answer choices 60.0% 65.0% 70.0% 75.0% Question 10 What is the firm's Inventory Turnover? 4.41 4.55 4.69 4.83 Question 11 What is the firm's DPS…
BALANCE SHEETCash $ 140.0 Accounts payable $ 800 .0Accts. receivable 880 .0 Notes payable 600.0Inventories 1,320.0 Accruals 400 .0Total current assets $2,340.0 Total current liabilities $1,800.0Long-term bonds 1,000.0Total debt $2,800.0Common stock 200 .0Retained earnings 1,000.0Net plant & equip. 1,660.0 Total common equity $1,200.0Total assets $4.000.0 Total liabilities & equity $4.000.0lNCOME STATEMENTNet sales $6,000.0Operating costs 5,599.8Depreciation 100.2EBIT $ 300.0Less: Interest 96 .0EBT $ 204 .0Less: Taxes 81.6Net income $ 122.4OTHER DATAAnnual Principal and Lease Payments 0.00Shares outstanding (millions) 60 .00Common dividends (millions) $42.8Interest rate on NIP and long-term bonds 6.0 %Federal plus state income tax rate 40%Year-end stock price $30 .60 Question 5 What is the firm's EBITDA coverage? Group of answer choices 3.51 3.69 3.88 4.17 Question 6 What is the firms DSO (Days Sales Outstanding)? Group of answer choices 51.30 days 52.80 days 53.50…
38 - Entity A has paid 10000 TL of its 50000 TL debt to sellers by bank transfer. Which account is credited in the registration to be made?A) 320 SellersB) 321 Debt SecuritiesC) 100 CratesD) 102 BanksE) 120 Buyers
Capital 1 January 2019 350 000Drawings 20 000Sales (70% on credit) 950 000Gross profit 250 000Total expenses 80 000Bank favourable 26 000Net profit 74 000Trade creditors 26 000Property, plant and equipment 350 000Fixed deposit 20 000Inventory 72 000Trade Debtors 80 000Mortgage Loan 100 000 Additional InformationThe opening balance of the inventory, debtors and creditors was R50 000, R60 000 and R30 000respectively. Assume a 365 day year. Calculate the following ratios and explain what each ratio means in relation to theindustry average given in brackets. Show your calculations as marks will be awardedfor these. Round off to 2 decimal places. Q.2.1.3 Average creditors settlement period (60 days). Assume purchases are equalto cost of sales and 60% of all purchases are on credit. Q.2.2 Discuss how the solvency ratio is calculated and what is measured by this ratio. Please help with the both questions mentioned
Capital 1 January 2019 350 000Drawings 20 000Sales (70% on credit) 950 000Gross profit 250 000Total expenses 80 000Bank favourable 26 000Net profit 74 000Trade creditors 26 000Property, plant and equipment 350 000Fixed deposit 20 000Inventory 72 000Trade Debtors 80 000Mortgage Loan 100 000 Additional InformationThe opening balance of the inventory, debtors and creditors was R50 000, R60 000 and R30 000respectively. Assume a 365 day year. Calculate the following ratios and explain what each ratio means in relation to theindustry average given in brackets. Show your calculations as marks will be awardedfor these. Round off to 2 decimal places. Q.2.1.3 Average creditors settlement period (60 days). Assume purchases are equalto cost of sales and 60% of all purchases are on credit. Q.2.2 Discuss how the solvency ratio is calculated and what is measured by this ratio.
balance sheet on december 31,year 1 and december 31year 2 are presented below: assets dec 31 year 1 dec 31 year 2 liabilites dec 31 year 1 dec 31 year 2 cash 50 000 60 000 trade accounts payable 62 000 49 000 accounts receivable 95 000 89 000 interest payable 8 000 11 000 allowance for uncollectible accounts (4 000) (3 000) bonds payables 200 000 200 000 inventory 120 000 140 000 unamortized bond discount (15 000) (10 000) property plant and equipment 295 000 340 000 Equity 199 000 257 000 accumlated depreciation (102 000) (119 000) total assets 454 000 507 000 total liabilities 454 000 507 000 additional information for year 2 : cash payents to suppliers of merchandise were 180 000 sales revenue was 338 000 3 000 of accounts receivables was written off equipment was acquired for 65 000 depreciation expense was 30 000 interest expenses was 20 000 based on the above information calculate the following : 1. the cost of goods sold year 2. 2.…
37-a At the end of the operating period, a rediscount of 7.500 TL has been calculated for the debt securities. Accordingly, which of the following accounts is correct to use in the posting to be made at the end of the period ? a) 321 Debt Securities Hs. Credited 7.500 TL B) 647 Rediscount Interest Income Hs. Creditor 7.500 TL NS) 657 Rediscount Interest Expenses Hs. Borrower 7.500 TL D) 647 Rediscount Interest Income Hs. Borrower 7.500 TL TO) 321 Debt Securities Hs. Borrower 7.500 TL
Create T accounts for the following data Date Account name debit credit Jan 1 Cash 180000 Building 630000 Land 220000 Common stock 700000 Premium on issue of common stock 280000 Jan 1 Pre paid insurance 72000 cash 72000 Feb 1 cash 150000 3yr 4% note payable 150000 Mar 1 Cash 280000 Service revenue 280000 Jul 1 cash 485000 Discount on bond issued 15000 6% 5yr 500000 Dec 31 Interest on Bond expense 15000 cash 15000 Dec 31 Interest on note payable expense 29052 5yr 6% note payable 25000 cash 54052 Dec 31 Dividend 40000 Dividend payable 40000 Dec 31 Depreciation expense 21000 Accumulated Depreciation 21000 Dec 31 Insurance Expense 36000 prepaid insurance 36000
Question Content Area If $310,000 of 7% bonds are issued at 97, the amount of cash received from the sale is a.$331,700 b.$300,700 c.$310,000 d.$288,300
Assignment Q. = Ken recieved 30000 of interest from corporate bonds and money market accounts. Ans & what line on form 1040?
Use the common-size financial statements found here: ommon-Size Balance Sheet 2016Cash and marketable securities $ 480 1.5 %Accounts receivable 6,030 18.2Inventory 9,540 28.8Total current assets $ 16,050 48.5 %Net property, plant, and equipment 17,020 51.5Total assets $33,070 100.0 %Accounts payable $ 7,150 21.6 %Short-term notes 6,850 20.7Total current liabilities $ 14,000 42.3 %Long-term liabilities 7,010 21.2Total liabilities $ 21,010 63.5 %Total common shareholders’ equity 12,060 36.5Total liabilities and shareholders’ equity $33,070 100.0 %Common-Size Income Statement 2016Revenues $ 30,000 100.0 %Cost of goods sold (20,050) 66.8Gross profit $ 9,950 33.2 %Operating expenses (7,960) 26.5Net operating income $ 1,990 6.6 %Interest expense (940) 3.1Earnings before taxes $ 1,050 3.5 %Income taxes (382) 1.3Net income $668 2.2 % Specifically, write up a brief narrative that responds to the following questions: a. How much cash does Patterson have on hand relative to its total…
l-Itihad Corporation Balance SheetDecember 31, 2019AssetsLiability & EquityCurrent AssetsCurrent LiabilityCash$5,000Accounts payable22,000Short term securities10,000Accrual Account8,000Account Receivables30,000Short term debt6,000Inventory32,000Total Current Liability36,000Long-term debt40,000Total Current Assets77,000TotalLiability76,000Long term AssetsEquityNet Property & equipment70,000CommonStocks64,000Retained earnings17,000Total Equity81,000Total Liability and Equity157,000Other assts 10000Total Assets157,000Sur Corporation Income StatementDecember 31, 2019Other Financial information of Sur corporation December 31, 2019Net sales (revenue)$150,000· Average Number of Common shares outstanding 16,000 Shares· Market price of Common share $3.5Cost of goods sold80,000Gross profit70,000Operating expenses30,000EBIT- (Operating profit)40,000Interest expense10,000EBT- ( Earnings before taxes)30,000Income tax 10,000Net Income (net profit)20,000You have to find the following ratios…