Financial Ratios:

Anonymous
timer Asked: Nov 7th, 2016

Question description

Would someone be able to assist me in retrieving the key financial ratios from this Pro Forma 12 month budget income statement, struggling with the size of this income statement (please provide the numbers to each of the following listed below) PLease keep in mind this was a 12 month budget, I only had 3 months to work with from our QuickBooks course:

Debt to Equity Ratio (Total Liabilities/Equity) =

Current Ratio (Current Assets/Current Liabilities) =

Profit Margin (Net Income/Sales) =

Kristin Raina Interior Design 12-Month Pro Forma Income Statement For the Years February 2017 - February 2018 2017 February $ $ $ $ $ 2017 March 5.500,00 84,62 5.415,38 1.140,00 6.555,38 $ $ $ $ $ 6.600,00 6.600,00 3.700,00 2.900,00 7.240,00 $ 3.655,38 $ $ $ $ 200 725 150 50 $ $ $ $ 200 725 150 50 Taxes, Licenses & Reg. Fees Miscellaneous Depreciation & Amortization $ $ 1.325 160 $ $ 1.325 160 Total Operating Expenses $ 2.610,00 $ 2.610,00 Net Income Before Taxes Taxes on Income Net Income After Taxes $ 4.630,00 $ 1.045,38 $ 4.630,00 $ 1.045,38 REVENUE Gross Sales Less sales returns and allowances Net Sales Revenue Service Revenue Total revenue $ $ $ $ $ COST OF SALES Beginning inventory Add: Stock Purchases Total Goods Available for Sale Less Stock Inventory- Year End Cost of Goods Sold $ $ $ $ $ Gross Profit/(Loss) $ Wages and Salaries Insurance Utilities Office Supplies Interest Expenses 7.240,00 7.240,00 - OPERATING EXPENSES Inventory remains the same No further rent expense No wages and or salaries Company will continue to provide both sales and service on a monthly basis Larger space obtained will increase availibility for bith sales and services. Operating expenses will increase to about 30% Taxes on income 35% $ $ $ $ $ 2017 April 5.500,00 84,62 5.415,38 8.380,00 13.795,38 $ $ $ $ $ 2017 May 11.000,00 169,24 10.830,76 14.480,00 25.310,76 $ $ $ $ $ 2017 June 11.000,00 169,24 10.830,76 2.280,00 13.110,76 $ $ $ $ $ 2017 July 11.000,00 169,24 10.830,76 16.760,00 27.590,76 $ $ $ $ $ 2017 August 11.000,00 169,24 10.830,76 14.480,00 25.310,76 $ $ $ $ $ 3.700,00 2.900,00 6.600,00 3.700,00 2.900,00 $ $ $ $ $ 3.700,00 5.800,00 9.500,00 3.700,00 5.800,00 $ $ $ $ $ 3.700,00 5.800,00 9.500,00 3.700,00 5.800,00 $ $ $ $ $ 3.700,00 5.800,00 9.500,00 3.700,00 5.800,00 $ $ $ $ $ 3.700,00 5.800,00 9.500,00 3.700,00 5.800,00 $ 10.895,38 $ 19.510,76 $ 7.310,76 $ 21.790,76 $ 19.510,76 $ $ $ $ 200 725 150 50 $ $ $ $ $ 200,00 260,00 942,50 195,00 250,00 $ $ $ $ $ 200,00 260,00 942,50 195,00 250,00 $ $ $ $ $ 200,00 260,00 942,50 195,00 250,00 $ $ $ $ $ 200,00 260,00 942,50 195,00 250,00 $ $ 1.325 160 $ $ 1.722,50 360,00 $ $ 1.722,50 360,00 $ $ 1.722,50 360,00 $ $ 1.722,50 360,00 $ 2.610,00 $ 3.930,00 $ 3.930,00 $ 3.930,00 $ 3.930,00 $ 8.285,38 $ 8.285,38 $ $ $ 15.580,76 5.453,27 10.127,49 $ $ $ 3.380,76 1.183,27 2.197,49 $ $ $ 17.860,76 6.251,27 11.609,49 $ $ $ 15.580,76 5.453,27 10.127,49 $ $ $ $ $ 2017 September 11.000,00 169,24 10.830,76 2.280,00 13.110,76 $ $ $ $ $ 2017 October 11.000,00 169,24 10.830,76 16.760,00 27.590,76 $ $ $ $ $ 2017 November 11.000,00 169,24 10.830,76 14.480,00 25.310,76 $ $ $ $ $ 2017 December 11.000,00 169,24 10.830,76 2.280,00 13.110,76 $ $ $ $ $ 2018 January 11.000,00 169,24 10.830,76 16.760,00 27.590,76 $ $ $ $ $ 3.700,00 5.800,00 9.500,00 3.700,00 5.800,00 $ $ $ $ $ 3.700,00 5.800,00 9.500,00 3.700,00 5.800,00 $ $ $ $ $ 3.700,00 5.800,00 9.500,00 3.700,00 5.800,00 $ $ $ $ $ 3.700,00 5.800,00 9.500,00 3.700,00 5.800,00 $ $ $ $ $ 3.700,00 5.800,00 9.500,00 3.700,00 5.800,00 $ 7.310,76 $ 21.790,76 $ 19.510,76 $ 7.310,76 $ 21.790,76 $ $ $ $ $ 200,00 260,00 942,50 195,00 250,00 $ $ $ $ $ 200,00 260,00 942,50 195,00 250,00 $ $ $ $ $ 200,00 260,00 942,50 195,00 250,00 $ $ $ $ $ 200,00 260,00 942,50 195,00 250,00 $ $ $ $ $ 200,00 260,00 942,50 195,00 250,00 $ $ 1.722,50 360,00 $ $ 1.722,50 360,00 $ $ 1.722,50 360,00 $ $ 1.722,50 360,00 $ $ 1.722,50 360,00 $ 3.930,00 $ 3.930,00 $ 3.930,00 $ 3.930,00 $ 3.930,00 $ $ $ 3.380,76 1.183,27 2.197,49 $ $ $ 17.860,76 6.251,27 11.609,49 $ $ $ 15.580,76 5.453,27 10.127,49 $ $ $ 3.380,76 1.183,27 2.197,49 $ $ $ 17.860,76 6.251,27 11.609,49 $ $ $ $ $ 2018 February 11.000,00 169,24 10.830,76 14.480,00 25.310,76 $ $ $ $ $ 2018 March 11.000,00 169,24 10.830,76 2.280,00 13.110,76 $ $ $ $ $ 2018 April 11.000,00 169,24 10.830,76 16.760,00 27.590,76 $ $ $ $ $ 3.700,00 5.800,00 9.500,00 3.700,00 5.800,00 $ $ $ $ $ 3.700,00 5.800,00 9.500,00 3.700,00 5.800,00 $ $ $ $ $ 3.700,00 5.800,00 9.500,00 3.700,00 5.800,00 $ 19.510,76 $ 7.310,76 $ 21.790,76 $ $ $ $ $ 200,00 260,00 942,50 195,00 250,00 $ $ $ $ $ 200,00 260,00 942,50 195,00 250,00 $ $ $ $ $ 200,00 260,00 942,50 195,00 250,00 $ $ 1.722,50 360,00 $ $ 1.722,50 360,00 $ $ 1.722,50 360,00 $ 3.930,00 $ 3.930,00 $ 3.930,00 $ $ $ 15.580,76 5.453,27 10.127,49 $ $ $ 3.380,76 1.183,27 2.197,49 $ $ $ 17.860,76 6.251,27 11.609,49
Kristin Raina Interior Design 12-Month Pro Forma Income Statement For the Years February 2017 - February 2018 2017 February $ $ $ $ $ 2017 March 5.500,00 84,62 5.415,38 1.140,00 6.555,38 $ $ $ $ $ 6.600,00 6.600,00 3.700,00 2.900,00 7.240,00 $ 3.655,38 $ $ $ $ 200 725 150 50 $ $ $ $ 200 725 150 50 Taxes, Licenses & Reg. Fees Miscellaneous Depreciation & Amortization $ $ 1.325 160 $ $ 1.325 160 Total Operating Expenses $ 2.610,00 $ 2.610,00 Net Income Before Taxes Taxes on Income Net Income After Taxes $ 4.630,00 $ 1.045,38 $ 4.630,00 $ 1.045,38 REVENUE Gross Sales Less sales returns and allowances Net Sales Revenue Service Revenue Total revenue $ $ $ $ $ COST OF SALES Beginning inventory Add: Stock Purchases Total Goods Available for Sale Less Stock Inventory- Year End Cost of Goods Sold $ $ $ $ $ Gross Profit/(Loss) $ Wages and Salaries Insurance Utilities Office Supplies Interest Expenses 7.240,00 7.240,00 - OPERATING EXPENSES Inventory remains the same No further rent expense No wages and or salaries Company will continue to provide both sales and service on a monthly basis Larger space obtained will increase availibility for bith sales and services. Operating expenses will increase to about 30% Taxes on income 35% $ $ $ $ $ 2017 April 5.500,00 84,62 5.415,38 8.380,00 13.795,38 $ $ $ $ $ 2017 May 11.000,00 169,24 10.830,76 14.480,00 25.310,76 $ $ $ $ $ 2017 June 11.000,00 169,24 10.830,76 2.280,00 13.110,76 $ $ $ $ $ 2017 July 11.000,00 169,24 10.830,76 16.760,00 27.590,76 $ $ $ $ $ 2017 August 11.000,00 169,24 10.830,76 14.480,00 25.310,76 $ $ $ $ $ 3.700,00 2.900,00 6.600,00 3.700,00 2.900,00 $ $ $ $ $ 3.700,00 5.800,00 9.500,00 3.700,00 5.800,00 $ $ $ $ $ 3.700,00 5.800,00 9.500,00 3.700,00 5.800,00 $ $ $ $ $ 3.700,00 5.800,00 9.500,00 3.700,00 5.800,00 $ $ $ $ $ 3.700,00 5.800,00 9.500,00 3.700,00 5.800,00 $ 10.895,38 $ 19.510,76 $ 7.310,76 $ 21.790,76 $ 19.510,76 $ $ $ $ 200 725 150 50 $ $ $ $ $ 200,00 260,00 942,50 195,00 250,00 $ $ $ $ $ 200,00 260,00 942,50 195,00 250,00 $ $ $ $ $ 200,00 260,00 942,50 195,00 250,00 $ $ $ $ $ 200,00 260,00 942,50 195,00 250,00 $ $ 1.325 160 $ $ 1.722,50 360,00 $ $ 1.722,50 360,00 $ $ 1.722,50 360,00 $ $ 1.722,50 360,00 $ 2.610,00 $ 3.930,00 $ 3.930,00 $ 3.930,00 $ 3.930,00 $ 8.285,38 $ 8.285,38 $ $ $ 15.580,76 5.453,27 10.127,49 $ $ $ 3.380,76 1.183,27 2.197,49 $ $ $ 17.860,76 6.251,27 11.609,49 $ $ $ 15.580,76 5.453,27 10.127,49 $ $ $ $ $ 2017 September 11.000,00 169,24 10.830,76 2.280,00 13.110,76 $ $ $ $ $ 2017 October 11.000,00 169,24 10.830,76 16.760,00 27.590,76 $ $ $ $ $ 2017 November 11.000,00 169,24 10.830,76 14.480,00 25.310,76 $ $ $ $ $ 2017 December 11.000,00 169,24 10.830,76 2.280,00 13.110,76 $ $ $ $ $ 2018 January 11.000,00 169,24 10.830,76 16.760,00 27.590,76 $ $ $ $ $ 3.700,00 5.800,00 9.500,00 3.700,00 5.800,00 $ $ $ $ $ 3.700,00 5.800,00 9.500,00 3.700,00 5.800,00 $ $ $ $ $ 3.700,00 5.800,00 9.500,00 3.700,00 5.800,00 $ $ $ $ $ 3.700,00 5.800,00 9.500,00 3.700,00 5.800,00 $ $ $ $ $ 3.700,00 5.800,00 9.500,00 3.700,00 5.800,00 $ 7.310,76 $ 21.790,76 $ 19.510,76 $ 7.310,76 $ 21.790,76 $ $ $ $ $ 200,00 260,00 942,50 195,00 250,00 $ $ $ $ $ 200,00 260,00 942,50 195,00 250,00 $ $ $ $ $ 200,00 260,00 942,50 195,00 250,00 $ $ $ $ $ 200,00 260,00 942,50 195,00 250,00 $ $ $ $ $ 200,00 260,00 942,50 195,00 250,00 $ $ 1.722,50 360,00 $ $ 1.722,50 360,00 $ $ 1.722,50 360,00 $ $ 1.722,50 360,00 $ $ 1.722,50 360,00 $ 3.930,00 $ 3.930,00 $ 3.930,00 $ 3.930,00 $ 3.930,00 $ $ $ 3.380,76 1.183,27 2.197,49 $ $ $ 17.860,76 6.251,27 11.609,49 $ $ $ 15.580,76 5.453,27 10.127,49 $ $ $ 3.380,76 1.183,27 2.197,49 $ $ $ 17.860,76 6.251,27 11.609,49 $ $ $ $ $ 2018 February 11.000,00 169,24 10.830,76 14.480,00 25.310,76 $ $ $ $ $ 2018 March 11.000,00 169,24 10.830,76 2.280,00 13.110,76 $ $ $ $ $ 2018 April 11.000,00 169,24 10.830,76 16.760,00 27.590,76 $ $ $ $ $ 3.700,00 5.800,00 9.500,00 3.700,00 5.800,00 $ $ $ $ $ 3.700,00 5.800,00 9.500,00 3.700,00 5.800,00 $ $ $ $ $ 3.700,00 5.800,00 9.500,00 3.700,00 5.800,00 $ 19.510,76 $ 7.310,76 $ 21.790,76 $ $ $ $ $ 200,00 260,00 942,50 195,00 250,00 $ $ $ $ $ 200,00 260,00 942,50 195,00 250,00 $ $ $ $ $ 200,00 260,00 942,50 195,00 250,00 $ $ 1.722,50 360,00 $ $ 1.722,50 360,00 $ $ 1.722,50 360,00 $ 3.930,00 $ 3.930,00 $ 3.930,00 $ $ $ 15.580,76 5.453,27 10.127,49 $ $ $ 3.380,76 1.183,27 2.197,49 $ $ $ 17.860,76 6.251,27 11.609,49
9:49 PM 11/06/16 Accrual Basis CH7 Ryan Lund Kristin Raina Interior Designs Balance Sheet All Transactions Apr 1, 17 ASSETS Current Assets Checking/Savings 1010 · Cash - Operating Total Checking/Savings 50,855.38 50,855.38 Accounts Receivable 1200 · Accounts Receivable Total Accounts Receivable 1,540.00 1,540.00 Other Current Assets 1260 · Inventory of Carpets 800.00 1265 · Inventory of Draperies 1,000.00 1270 · Inventory of Lamps 1,000.00 1275 · Inventory of Mirrors 900.00 1300 · Design Supplies 200.00 1305 · Office Supplies 250.00 1410 · Prepaid Advertising 1420 · Prepaid Insurance Total Other Current Assets Total Current Assets 500.00 2,200.00 6,850.00 59,245.38 Fixed Assets 1700 · Furniture 1725 · Furniture, Cost 1750 · Accum. Dep., Furniture Total 1700 · Furniture 12,000.00 -100.00 11,900.00 1800 · Computers 1825 · Computers, Cost 1850 · Accum. Dep., Computers Total 1800 · Computers Total Fixed Assets TOTAL ASSETS 3,600.00 -60.00 3,540.00 15,440.00 74,685.38 LIABILITIES & EQUITY Liabilities Current Liabilities Accounts Payable 2010 · Accounts Payable Total Accounts Payable 9,750.00 9,750.00 Other Current Liabilities 2020 · Notes Payable 2030 · Interest Payable Total Other Current Liabilities Total Current Liabilities Total Liabilities 7,000.00 50.00 7,050.00 16,800.00 16,800.00 Equity 3010 · Kristin Raina, Capital 3020 · Kristin Raina, Drawings 50,000.00 -400.00 Page 4 of 5 9:49 PM 11/06/16 Accrual Basis CH7 Ryan Lund Kristin Raina Interior Designs Balance Sheet All Transactions Apr 1, 17 Net Income Total Equity TOTAL LIABILITIES & EQUITY 8,285.38 57,885.38 74,685.38 Page 5 of 5

Tutor Answer

(Top Tutor) Studypool Tutor
School: UT Austin
Studypool has helped 1,244,100 students
flag Report DMCA
Similar Questions
Hot Questions
Related Tags
Study Guides

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors