Purchase Solution

Balance Sheet from ratios

Not what you're looking for?

Ask Custom Question

Initially founded as a consulting business in 1984, Hummingbird quickly evolved into a dominant player in the connectivity market. To keep pace with increased demand and competition within the industry the company is expanding its activities since last year.

One of the newly appointed management trainees, Miss Lily is preparing a note on the utilization of funds of the company in year 2011-12 as compared to that in year 2010-11. The balance sheet of the company is not available to the management trainee due to some policy matters of the company. However, she gathers information regarding some ratios of the company.

Year 2010-11 2011-12
Current ratio 2.3 1.6
Liquid ratio 1.4 0.7
Fixed asset to Proprietary funds 0.75 0.85
Bank OD 120,000 160,000
Working capital 325,000 360,000

There were no term loans or intangible assets of the company.
From the above information, prepare a comparative balance sheet for the years 2010-11 and 2011-12.

Attachments
Purchase this Solution

Solution Summary

This solution provides calculations in Excel for the various components of a balance sheet.

Purchase this Solution


Free BrainMass Quizzes
Change and Resistance within Organizations

This quiz intended to help students understand change and resistance in organizations

Understanding the Accounting Equation

These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.

Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.

Production and cost theory

Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.

Marketing Management Philosophies Quiz

A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.