Answered step by step
Verified Expert Solution
Link Copied!

Question

...
1 Approved Answer

I have to prepare a forecasted Balance sheet for 2011 (data given) - 2017. I have included my own formulas for computation but unsure how

I have to prepare a forecasted Balance sheet for 2011 (data given) - 2017. I have included my own formulas for computation but unsure how to include calculations for my assumptions. Please help with how I am to apply the formula or calculation to each assumption so I am able to do it going forward Assume a 3% growth rate and Tax of 33%

Current Assests:
Cash and cash equivalents $ 3,112 For each year, a plug number, that makes the balance sheet balance
Trade receivables, net $ 98,218 Change per the rate of sales growth
Inventories $ 145,575 Change per the rate of sales growth
Deferred tax assets, current $ 13,249 The proportion of deferred tax assets to income tax expenses will remain the same as in 2011
Prepaid income taxes $ 2,783 No change; the same number each year as in 2011
Property Held for Sale
Prepaid expenses and other current assets $ 13,102 Change per the rate of sales growth
Total Current Assets $ 276,039
Restricted cash $ 15,795 Change per the rate of sales growth
Property, Plant and Equipment (gross) $ 247,645 Consistent with the recent trend, assume that PPE Turnover (Sales/Yearend PPE) will decrease by 0.2 each year
Accumulated Depreciation Property, plant and equipment $ (120,238) Balance at the beginning of the year + Depreciation expenses for the year
Property, Plant and Equipment (Net) $ 127,407
Deferred income taxes $ 3,870 The proportion of deferred income taxes to income tax expenses will remain the same as in 2011

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

International Financial Reporting A Practical Guide

Authors: Alan Melville

6th edition

978-1292200743

Students also viewed these Accounting questions

Question

Explain all drawbacks of application procedure.

Answered: 1 week ago