Answered step by step
Verified Expert Solution
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](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
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](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started