Question

Paul Sabin organized Sabin Electronics 10 years ago to produce and se several electronic devices on which he had secured pateRequired: 1. To assist in approaching the bank about the loan, Paul has asked you to compute the following ratios for both thRequired: 1. To assist in approaching the bank about the loen, Paul has asked you to compute the following ratios for both th

0 0
Add a comment Improve this question Transcribed image text
Answer #1
Sabin Electronics
Common Size Balance Sheet
This Year Percent Working Last Year Percent Working
Assets
Cash $               1,10,000.00 3% ($110000/$3738400) $                              2,50,000.00 9% ($250000/$2875000)
Marketable Securities $                                  -   0% $                                  28,000.00 1% ($28000/$2875000)
Accounts Receivable $               6,07,000.00 16% ($607000/$3738400) $                              4,00,000.00 14% ($400000/$2875000)
Inventories $             10,45,000.00 28% ($1045000/$3738400) $                              6,95,000.00 24% ($695000/$2875000)
Prepaid expenses $                   30,000.00 1% ($30000/$3738400) $                                  32,000.00 1% ($32000/$2875000)
Total Current Assets=(A) $             17,92,000.00 48% ($1792000/$3738400) $                            14,05,000.00 49% ($1405000/$2875000)
Net Property,Plant & Equipment=(B) $             19,46,400.00 52% ($1946400/$3738400) $                            14,70,000.00 51% ($1470000/$2875000)
Total Assets=(A)+(B) $             37,38,400.00 100% ($3738400/$3738400) $                            28,75,000.00 100% ($2875000/$2875000)
Liabilities & Stockholder's Equity
Current Liabilities $               8,50,000.00 23% ($850000/$3738400) $                              4,00,000.00 14% ($400000/$2875000)
Bonds Payable 12% $               7,50,000.00 20% ($750000/$3738400) $                              7,50,000.00 26% ($750000/$2875000)
Total Liabilities=(C ) $             16,00,000.00 43% ($1600000/$3738400) $                            11,50,000.00 40% ($1150000/$2875000)
Stockholder's Equity 0%
Common Stock $               7,90,000.00 21% ($790000/$3738400) $                              7,90,000.00 27% ($790000/$2875000)
Retained Earnings $             13,48,400.00 36% ($1348400/$3738400) $                              9,35,000.00 33% ($935000/$2875000)
Total Stockholder's Equity=(D) $             21,38,400.00 57% ($2138400/$3738400) $                            17,25,000.00 60% ($1725000/$2875000)
Total Liabilities & Stockholder's Equity=(C)+(D) $             37,38,400.00 100% ($3738400/$3738400) $                            28,75,000.00 100% ($2875000/$2875000)
Sabin Electronics
Common Size Income Statement
This Year Percent Working Last Year
Sales $             55,00,000.00 100.00 % ($5500000/$5500000)*100 $     46,50,000.00 100.00
Cost of goods sold $             39,75,000.00 72.27 % ($3975000/$5500000)*100 $     35,50,000.00 76.34
Gross Margin $             15,25,000.00 27.73 % ($1525000/$5500000)*100 $     11,00,000.00 23.66
Selling & Administrative Expenses $               6,73,000.00 12.24 % ($673000/$5500000)*100 $        5,68,000.00 12.22
Net operating income $               8,52,000.00 0.15 % ($852000/$5500000)*100 $        5,32,000.00 0.11
Interest Expense $                   90,000.00 0.02 % ($90000/$5500000)*100 $           90,000.00 0.02
Income Before Taxes $               7,62,000.00 13.85 % ($762000/$5500000)*100 $        4,42,000.00 9.51
Income Tax Expense $               2,28,600.00 0.04 % ($228600/$5500000)*100 $        1,32,600.00 0.03
Net Income $               5,33,400.00 9.70 % ($533400/$5500000)*100 $        3,09,400.00 6.65
Add a comment
Know the answer?
Add Answer to:
Paul Sabin organized Sabin Electronics 10 years ago to produce and se several electronic devices on...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Paul Sabin organized Sabin Electronics 10 years ago to produce and sell several electronic devices on...

    Paul Sabin organized Sabin Electronics 10 years ago to produce and sell several electronic devices on which he had secured patents. Although the company has been fairly profitable, it is now experiencing a severe cash shortage. For this reason, it is requesting a $640,000 long-term loan from Gulfport State Bank, $170,000 of which will be used to bolster the Cash account and $470,000 of which will be used to modernize equipment. The company's financial statements for the two most recent...

  • Paul Sabin organized Sabin Electronics 10 years ago to produce and sell several electronic devices on...

    Paul Sabin organized Sabin Electronics 10 years ago to produce and sell several electronic devices on which he had secured patents. Although the company has been fairly profitable, it is now experiencing a severe cash shortage. For this reason, it is requesting a $600,000 long-term loan from Gulfport State Bank, $150,000 of which will be used to bolster the Cash account and $450,000 of which will be used to modernize equipment. The company's financial statements for the two most recent...

  • Paul Sabin organized Sabin Electronics 10 years ago to produce and sell several electronic devices on...

    Paul Sabin organized Sabin Electronics 10 years ago to produce and sell several electronic devices on which he had secured patents. Although the company has been fairly profitable, it is now experiencing a severe cash shortage. For this reason, it is requesting a $590,000 long-term loan from Gulfport State Bank, $145,000 of which will be used to bolster the Cash account and $445,000 of which will be used to modernize equipment. The company’s financial statements for the two most recent...

  • Paul Sabin organized Sabin Electronics 10 years ago to produce and sell several electronic devices on...

    Paul Sabin organized Sabin Electronics 10 years ago to produce and sell several electronic devices on which he had secured patents. Although the company has been fairly profitable, it is now experiencing a severe cash shortage. For this reason, it is requesting a $660,000 long-term loan from Gulfport State Bank, $180,000 of which will be used to bolster the Cash account and $480,000 of which will be used to modernize equipment. The company's financial statements for the two most recent...

  • Paul Sabin organized Sabin Electronics 10 years ago to produce and sell several electronic devices on...

    Paul Sabin organized Sabin Electronics 10 years ago to produce and sell several electronic devices on which he had secured patents. Although the company has been fairly profitable, it is now experiencing a severe cash shortage. For this reason, it is requesting a $590,000 long-term loan from Gulfport State Bank, $145,000 of which will be used to bolster the Cash account and $445,000 of which will be used to modernize equipment. The company’s financial statements for the two most recent...

  • Paul Sabin organized Sabin Electronics 10 years ago to produce and sell several electronic devices on...

    Paul Sabin organized Sabin Electronics 10 years ago to produce and sell several electronic devices on which he had secured patents. Although the company has been fairly profitable, it is now experiencing a severe cash shortage. For this reason, it is requesting a $540,000 long-term loan from Gulfport State Bank, $120,000 of which will be used to bolster the Cash account and $420,000 of which will be used to modernize equipment. The company’s financial statements for the two most recent...

  • Paul Sabin organized Sabin Electronics 10 years ago to produce and sell several electronic devices on...

    Paul Sabin organized Sabin Electronics 10 years ago to produce and sell several electronic devices on which he had secured patents. Although the company has been fairly profitable, it is now experiencing a severe cash shortage. For this reason, it is requesting a $590,000 long-term loan from Gulfport State Bank, $145,000 of which will be used to bolster the Cash account and $445,000 of which will be used to modernize equipment. The company's financial statements for the two most recent...

  • Paul Sabin organized Sabin Electronics 10 years ago to produce and sell several electronic devices on...

    Paul Sabin organized Sabin Electronics 10 years ago to produce and sell several electronic devices on which he had secured patents. Although the company has been fairly profitable, it is now experiencing a severe cash shortage. For this reason, it is requesting a $580,000 long-term loan from Gulfport State Bank, $140,000 of which will be used to bolster the Cash account and $440,000 of which will be used to modernize equipment. The company’s financial statements for the two most recent...

  • Paul Sabin organized Sabin Electronics 10 years ago to produce and sell several electronic device...

    Paul Sabin organized Sabin Electronics 10 years ago to produce and sell several electronic devices on which he had secured patents. Although the company has been fairly profitable, it is now experiencing a severe cash shortage. For this reason, it is requesting a $500,000 long-term loan from Gulfport State Bank, $100,000 of which will be used to bolster the Cash account and $400,000 of which will be used to modernize equipment. The company's financial statements for the two most recent...

  • Paul Sabin organized Sabin Electronics 10 years ago to produce and sell several electronic devices on...

    Paul Sabin organized Sabin Electronics 10 years ago to produce and sell several electronic devices on which he had secured patents. Although the company has been fairly profitable, it is now experiencing a severe cash shortage. For this reason, it is requesting a $510,000 long-term loan from Gulfport State Bank, $105,000 of which will be used to bolster the Cash account and $405,000 of which will be used to modernize equipment. The company's financial statements for the two most recent...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT