Explore BrainMass

Explore BrainMass

    Balance Sheet from ratios

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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.

    © BrainMass Inc. brainmass.com June 4, 2020, 5:04 am ad1c9bdddf


    Solution Summary

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