Question: The above question is needed to be solved in excel. Question 2: Prepare balance sheet from the following information: Current ratio 1.75 Quick ratio 1.25

The above question is needed to be solved in excel.

Question 2: Prepare balance sheet from the following information: Current ratio 1.75 Quick ratio 1.25 Stock turnover ratio (cost of sales/ Closing stock) 9 9 Gross profit ratio 25% Debt collection period 1.5 months Reserve and surplus to capital 0.2 Turnover to fixed assets 1.2 Capital gearing ratio (Long term debt to equity capital) 0.6 Fixed assets to net worth 1.25 Sales for the year Rs.12.00.000 IUL 2. Balance sheet total Rs.11,00,000

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Please i need help with this homework. Zoom in to see everything clearly I need Help with my homework. actions Input area: In ThousandsS Cost of goods sold Cash Depreciation Interest expense Selling...

TaIn . University of the Cordilleras College of Business Administration - Graduate School TEST QUESTIONS IFM, MAC 1 and MAC 2 Cluster Direction: Answer the following cases in a one whole sheet of...

The questions are attached bellow and I would like help to solve them iPad '3 8:44 AM MBA 645A, Test 1 Dr. Wei Feng NAME: DATE: Part I - Multiple Choices (2 * 30 = 60 points) 1. Financial managers...

Select a publicly traded company as well as one of their competitors within the same industry and gather the latest two years of their financial statements.Prepare a horizontal analysis, vertical...

Please help me answer the profitability and Liquidity sections! a. c. 1. Compute the following ratios for the most recent year and include them in an Appendix to this report. [The calculations for...

The company is Home Depot and the competitor is Lowes a. c. 1. Compute the following ratios for the most recent year and include them in an Appendix to this report. [The calculations for each of...

The company is Home Depot and the competitor is Lowes This is the best quality I can get, to view them I zoom in on the page. a. c. 1. Compute the following ratios for the most recent year and...

the question information: 4. Analyze the overall financial situation from a cross-sectional viewpoint. Compare each company's ratios with the industry average. What are the strengths and weaknesses...

I need help with the A-K part a. c. 1. Compute the following ratios for the most recent year and include them in an Appendix to this report. [The calculations for each of these ratios can be found in...

Can a self-employed person claim expenditure deductions on the following: (refer to the Income Tax Act 2007) NZ 1-Professional society/membership relating to their work 2-Computer to be used for...

Whitegloves Janitorial Service was started 2 years ago by Nancy Kohl. Because business has been exceptionally good, Nancy decided on July 1, 2012, to expand operations by acquiring an additional...

How does the environment, technology, and geopolitical power impact the choice of the author's start date in 1 4 0 0 ?

a=2 b= 0 c= 2 d=0 e=0 f=9 g=3 5. Draw the Network diagram for the following project. Estimate the Earliest start time and Latest finish time for each activity. If every day it cost 200 rials for this...