Prepare proforma quarterly forecasts of Profit and Loss Statement and Balance Sheet for Amber Enterprises based on
Question:
Prepare proforma quarterly forecasts of Profit and Loss Statement and Balance Sheet for Amber Enterprises based on assumptions provided in Exhibit 2.5.
Transcribed Image Text:
EXHIBIT 2.5 Assumptions for Proforma Forecasting Revenues from Operations Material Costs Employee Benefit Expenses Other Expenses Depreciation Property, Plant, and Equipment Other Non-current Assets 15% growth in annual sales. Distributed in the proportions of 32%, 13%, 18%, and 37% from Q1 to Q4 in that order. 83.5% (combined with change in inventories) of the revenues. 7% annual increase; of the total 80% fixed and evenly distributed, 20% varying with seasonal revenues. 12% annual increase; of the total 20% fixed and evenly distributed, 80% varying with seasonal revenues. 10% of property, plant, and equipment. Increase of 150 million in each quarter. An increase of 1000 million each in Q1 and Q2 expected for ongoing acquisition. Cash and Bank Balance Minimum level of Rs 400 million, plug to balance on Trade Receivables Inventory Other Current Assets Equity Share Capital Other Equity Non-current Borrowings Other Non-current Liabilities Trade Payables Current Borrowings the asset side. 2.33 months of sales. 2.5 months of total operating expenses. Same as at the end of March 2019. No change. Change based only on profits, no dividends. Net increase 500 million in each quarter. Same as at the end of March 2019. Estimated as 3 months of cost of materials. Plug to balance on the liability side, minimum level of Rs 500 million. Other Current Liabilities Same as at the end of March 2019. Interest Cost Other Income Tax Rate At 10.5% of average total borrowings. At 8% of average cash and bank balance. At 30%.
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 100% (QA)
Answered By
Muhammad Umair
I have done job as Embedded System Engineer for just four months but after it i have decided to open my own lab and to work on projects that i can launch my own product in market. I work on different softwares like Proteus, Mikroc to program Embedded Systems. My basic work is on Embedded Systems. I have skills in Autocad, Proteus, C++, C programming and i love to share these skills to other to enhance my knowledge too.
3.50+
1+ Reviews
10+ Question Solved
Related Book For
Cases In Corporate Finance
ISBN: 978-1032724485
1st Edition
Authors: Mayank Joshipura ,Sachin Mathur
Question Posted:
Students also viewed these Business questions
-
please refer to screenshot and trainer feedback. i need help fixing these erros. documents to review for tasks: Spreadsheets: Trial balance Debit Credit Bank account Debtors Rental gond Motor...
-
Hye , can i get the answer for Case Study 2 - Financial Analysis of Boat Builders Pty Ltd, Credit Analysis and Lending Management. Question no 3 : Case study 2 - Financial analysis of Boat Builders...
-
Please help with the discusin questions ! I give thumbs up Case #1: Hailing a New Era: Haier in Japan As one of the most valuable brands in China, Haier designs,manufactures, and sells various home...
-
Which sentence below most strongly emphasizes the importance of the decision? (5 points) Over the next year, the direction of the company depends on the quick decision we must make. The direction of...
-
Consider the following system: with Using the Isim function obtain and plot the system response (for x1(t) and x2(t)) when u(t) = 0. 0 3 0-2y
-
The company with the equity accounts shown here has declared a 12 per cent stock dividend when the market value of its equity is 20 per share. What effects on the equity accounts will the...
-
Use the PewSocialMedia dataset to address this question: which variable has the biggest effect on respondents score on the Index of Cellphone Uses: education or income (for both of these variables,...
-
The county collector of Sun coast County is responsible for collecting all property taxes levied by funds and governments within the boundaries of the county. To reimburse the county for estimated...
-
Item Quantity Cost Usage Corn 100 Kilogram 200 1,000 portions Frying Pan (disposable 1 non-stick Self-heating) 100 1,000 portions Paper Cups 1,000 33 1,000 portions Required: Assume the business...
-
Prepare quarterly estimates of key profitability and solvency and liquidity indicators, including net profit margin, return on capital employed, debt to equity ratio, interest coverage ratio, and...
-
Is the decision to change the credit policy in FY21 prudent? Verify the same, assuming an opportunity cost of fund of 15.3% and a marginal tax rate of 25%.
-
What is the proper accounting treatment for the costs of removing or dismantling a company's old plant assets?
-
The ratio of CEO pay to that of an average employee increased over a period of 50 years from 24:1 to 275:1. Is this increasing gap ethically sound, in your opinion? Should CEO pay be limited in any...
-
Suppose you are considering buying a machine that costs $7,000. It will generate revenues of $1,500 for the next 3 years, and then $1,000 for the following 5 years. What is the payback period of this...
-
National Bakery Limited is the main supplier of a variety of baked products to customers in Kingston. The company currently makes 25,000,000 a variety of baked products annually which uses baking...
-
Q1. Discuss the financial goal of a business. Ensure to provide an example of the inherent ethical challenges associated with the financial goal and or the financial management process. Using the...
-
Q1. How can companies use social media to do sentiment analysis? Describe the process. Give an example of a company that uses sentiment analysis to enhance relationships with customers. Q2. Describe...
-
Suppose you observe the following 1-year interest rates, spot exchange rates and futures prices. Futures contracts are available on 10,000. How much risk-free arbitrage profit could you make on 1...
-
The roof of a refrigerated truck compartment is of composite construction, consisting of a layer of foamed urethane insulation (t2 = 50 mm, ki = 0.026 W/m K sandwiched between aluminum alloy panels...
-
Green Lawn Company sells garden supplies. Management is planning its cash needs for the second quarter. The following information has been assembled to assist in preparing a cash budget for the...
-
eBook Question Content Area Comparison of Methods of Allocation Duweynie Pottery, Inc., is divided into two operating divisions: Pottery and Retail. The company allocates Power and General Factory...
-
TYBALT CONSTRUCTION Income Statement For Year Ended December 31 TYBALT CONSTRUCTION Income Statement For Year Ended December 31
Study smarter with the SolutionInn App