Question

In: Accounting

Balance Sheet as at year end 31st Dec 2005 2006 2007 2008 2009 CAPITAL AND LIABILITIES:...

Balance Sheet as at year end 31st Dec

2005

2006

2007

2008

2009

CAPITAL AND

LIABILITIES:

Equity share capital

400,000

600,000

500,000

400,000

600,000

Long term loan

500,000

250,000

300,000

400,000

300,000

Sundry creditors

200,000

300,000

350,000

340,000

250,000

Short term loan

50,000

40,000

60,000

115,000

50,000

ASSETS:

Land and Building

300,000

500,000

600,000

700,000

450,000

Furniture

600,000

450,000

400,000

400,000

500,000

Cash at bank

50,000

60,000

70,000

50,000

70,000

Stock

140,000

150,000

100,000

80,000

120,000

Prepaid expenses

60,000

30,000

40,000

25,000

60,000

You are required to carry out the following analyses;

Common size balance sheet for the five years. and interpret. (5 marks

Solutions

Expert Solution

Balance Sheet as at year end 31st Dec
2005 2006 2007 2008 2009
CAPITAL AND
LIABILITIES:
Equity share capital 400,000 600,000 500,000 400,000 600,000
Long term loan 500,000 250,000 300,000 400,000 300,000
Sundry creditors 200,000 300,000 350,000 340,000 250,000
Short term loan 50,000 40,000 60,000 115,000 50,000
ASSETS:
Land and Building 300,000 500,000 600,000 700,000 450,000
Furniture 600,000 450,000 400,000 400,000 500,000
Cash at bank 50,000 60,000 70,000 50,000 70,000
Stock 140,000 150,000 100,000 80,000 120,000
Prepaid expenses 60,000 30,000 40,000 25,000 60,000
Common Size Balance Sheet as at year end 31st Dec
2005 2006 2007 2008 2009
CAPITAL AND
LIABILITIES:
Equity share capital 35% 50% 41% 32% 50%
Long term loan 43% 21% 25% 32% 25%
Sundry creditors 17% 25% 29% 27% 21%
Short term loan 4% 3% 5% 9% 4%
ASSETS:
Land and Building 26% 42% 50% 56% 38%
Furniture 52% 38% 33% 32% 42%
Cash at bank 4% 5% 6% 4% 6%
Stock 12% 13% 8% 6% 10%
Prepaid expenses 5% 3% 3% 2% 5%

Related Solutions

Consider the data in the following table: Year 2004 2005 2006 2007 2008 2009 Stock A...
Consider the data in the following table: Year 2004 2005 2006 2007 2008 2009 Stock A -10% 20% 5% -5% 2% 9% Stock B 21% 7% 30% -3% -8% 25% Use the above information to answer the following questions. Round your answers to four decimal places (i.e. 0.0105). 1. Estimate the average return for stock A. 2. Estimate the average return for stock B. 3. Estimate the volatility of stock A. 4.Estimate the volatility of stock B. 5 .Estimate the...
This is a tableau question. Year Sales 2005 49387 2006 53412 2007 56783 2008 58436 2009...
This is a tableau question. Year Sales 2005 49387 2006 53412 2007 56783 2008 58436 2009 59994 2010 61515 2011 63182 2012 67989 2013 70448 2014 72601 2015 75482 2016 78341 2017 81111 2018 82517 2019 83275 2020 84005 I. (a) Determine the trend line using both linear and two nonlinear equations Hint: You can choose any two of the nonlinear options in edit trend lines within Tableau. (b) Write down the equations (coefficients). Hint: Double click on trend line...
Year 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 Dividend $         7.46 $         7.91...
Year 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 Dividend $         7.46 $         7.91 $         8.38 $         8.80 $         9.24 $         9.70 $       10.28 $       10.79 $       11.33 $       12.01 Find both the arithmetic growth rate and the geometric growth rate of the dividends for Davy's Crock Pot Stores. Assuming the January​ 1, 2011 price of the stock is $110.00​, determine the current required rate of return for the company​ (use the geometric growth rate to calculate the...
PepsiCo Revenues ($ millions), 2005–2010 Quarter 2005 2006 2007 2008 2009 2010 Qtr1 6,585    7,205   ...
PepsiCo Revenues ($ millions), 2005–2010 Quarter 2005 2006 2007 2008 2009 2010 Qtr1 6,585    7,205    7,350    8,332 8,263   9,368 Qtr2 7,697    8,599    9,607    10,945 10,592   14,801 Qtr3 8,184    8,950    10,171    11,244   11,080   15,514 Qtr4 10,096    10,383    12,346    12,729   13,297   18,155 (b) State the model found when performing a regression using seasonal binaries. (A negative value should be indicated by a minus sign. Round your answers to 4 decimal places. yt =___...
PepsiCo Revenues ($ millions), 2005–2010 Quarter 2005 2006 2007 2008 2009 2010 Qtr1 6,585    7,205   ...
PepsiCo Revenues ($ millions), 2005–2010 Quarter 2005 2006 2007 2008 2009 2010 Qtr1 6,585    7,205    7,350    8,333 8,263   9,368 Qtr2 7,697    8,599    9,607    10,945 10,592   14,801 Qtr3 8,184    8,950    10,171    11,244   11,080   15,514 Qtr4 10,096    10,383    12,346    12,729   13,297   18,155 (b) State the model found when performing a regression using seasonal binaries. (A negative value should be indicated by a minus sign. Round your answers to 4 decimal places. yt =___...
Coca-Cola Revenues ($ millions), 2005–2010 Quarter 2005 2006 2007 2008 2009 2010 Qtr1 5,206 5,131 6,090...
Coca-Cola Revenues ($ millions), 2005–2010 Quarter 2005 2006 2007 2008 2009 2010 Qtr1 5,206 5,131 6,090 7,410 7,180 7,516 Qtr2 6,310 6,480 7,720 9,060 8,232 8,665 Qtr3 6,037 6,422 7,677 8,314 8,040 8,417 Qtr4 5,551 5,920 7,318 7,100 7,498 10,485 Click here for the Excel Data File (a-1) Use MegaStat or Minitab to deseasonalize Coca-Cola’s quarterly data. (Round your answers to 3 decimal places.) 1 2 3 4 2005 2006 2007 2008 2009 2010 mean (a-2) State the adjusted four...
Coca-Cola Revenues ($ millions), 2005–2010 Quarter 2005 2006 2007 2008 2009 2010 Qtr1 5,200 5,117 6,075...
Coca-Cola Revenues ($ millions), 2005–2010 Quarter 2005 2006 2007 2008 2009 2010 Qtr1 5,200 5,117 6,075 7,380 7,150 7,800 Qtr2 6,304 6,465 7,705 9,045 8,220 8,659 Qtr3 6,031 6,410 7,662 8,305 8,025 8,411 Qtr4 5,545 5,905 7,303 7,040 7,480 10,479 (a-1) Use MegaStat or Minitab to deseasonalize Coca-Cola’s quarterly data. (Round your answers to 3 decimal places.) 1 2 3 4 2005 2006 2007 2008 2009 2010 mean (a-2) State the adjusted four quarterly indexes. (Round your answers to 3...
ABC CORPORATION Balance Sheet Year Ended December 31 (in $ millions) Assets 2006 2005 Liabilities &...
ABC CORPORATION Balance Sheet Year Ended December 31 (in $ millions) Assets 2006 2005 Liabilities & Stockowner’s Equity 2006 2005 Current Assets Current Liabilities Cash 22.2 19.5 Accounts Payable 39.2 24.5 Accounts Receivables 18.5 13.2 Notes Payable / Short-Term Debt 4.5 3.2 Inventories 27.2 14.3 Current Maturities of Long-Term Debt 13.3 12.3 Other Current Assets 2.0 1.0 Other Current Liabilities 8.0 4.0 Total Current Assets 69.9 48.0 Total Current Liabilities 65.0 45.0 Long Term Assets Long-Term Liabilities Land 22.2 20.7...
India's Current Account Assumptions​ (millions USD) 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013...
India's Current Account Assumptions​ (millions USD) 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 ​Goods: exports ​77,939 ​102,175 ​123,876 ​153,530 ​199,065 ​167,958 ​230,967 ​307,847 ​298,321 ​319,110 ​329,633 ​Goods: imports ​-95,539 ​-134,692 ​-166,572 ​-208,611 ​-291,740 ​-247,908 ​-324,320 ​-428,021 ​-450,249 ​-433,760 ​-415,529      Balance on goods ​-17,600 ​-32,517 ​-42,696 ​-55,081 ​-92,675 ​-79,950 ​-93,353 ​-120,174 ​-151,928 ​-114,650 ​-85,895 ​Services: credit ​38,281 ​52,527 ​69,440 ​86,552 ​106,054 ​92,889 ​117,068 ​138,528 ​145,525 ​148,649 ​156,252 ​Services: debit ​-35,641 ​-47,287 ​-58,514 ​-70,175 ​-87,739 ​-80,349 ​-114,739 ​-125,041...
Balance Sheets as on 31st Dec 2017 & 31st Dec 2018 31st Dec 2017 31st Dec...
Balance Sheets as on 31st Dec 2017 & 31st Dec 2018 31st Dec 2017 31st Dec 2018 Current Assets: Cash $65,000 $80,000 Accounts Receivables $2,500,000 $4,000,000 Inventory $1,500,000 $2,500,000 Total Current Assets $4,065,000 $6,580,000 Fixed Assets: Buildings $2,000,000 $3,000,000 Furniture & office equipment $1,100,000 $1,400,000 Good Will $6,100,000 $5,700,000 Patents $1,000,000 $1,100,000 Total Fixed Assets $10,200,000 $11,200,000 Total Assets $14,265,000 $17,780,000 Liabilities: Current Liabilities: Accounts Payable $1,200,000 $1,350,000 Notes Payable $500,000 $550,000 Interest Payable $110,000 $125,000 Total Current Liabilities $1,810,000...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT