FORECASTING ASSIGNMENT - Mantly Inc. Assume you are the Financial Analyst for Mantly Inc., and it...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
FORECASTING ASSIGNMENT - Mantly Inc. Assume you are the Financial Analyst for Mantly Inc., and it is January 1, 2022. Mantly Inc., a manufacturing company, has been growing quickly, but it has found that its financial situation is continually under pressure. Production has fluctuated to meet demand in an attempt to provide first-class service, resulting in larger inventory positions. Also, the collection of accounts has worsened to approximately 60 days, which is well above the invoice terms of net 30 days. To address the financial concerns, Mantly Inc. has proposed level production and an expected effort by the credit department to bring the average collection period down to 35 days. Estimated sales for the upcoming months are as follows: January 5978,750 February 1,035,000 March 1,102,500 April 1.181,250 May 1.237.500 June 1,282,500 Sales for November were $866,250 and will be approximately $922,500 for the just completed month of December. It is projected that the current collection period of 60 days will be reduced to 50 days for January and February and to 42 days for March and April, and will meet the target of 35 days in May and June. Inventory purchases are forecast to be $292,500 a month beginning in January. In November they were $337,500, and in December they are expected to be $303,750. The purchases are paid in 40 days. Manufacturing labour expense will be paid as incurred and will be $97,500 a month. Other expenses of manufacturing will also be paid as incurred and are expected to be $187,500 a month. Cost of goods sold has regularly been 70% of sales. Amortization is $19,000 per month. Selling and administrative expenses are expected to be 13 percent of sales (and also paid as incurred). The tax rate is 42 percent. There will be payments on Notes Payable of $337,500 in each of February and May. Income taxes of $169,000 are due in April. Dividends of $11,250 and interest of $135,000 (3 months of interest) are payable in January and April. Current Assets: Cash MANTLY INC. Balance Sheet (Estimated) December, 2021 (S thousands) ASSETS Accounts Receivable Inventory Total Current Assets Capital Assets: Plant and Equipment Less: Accumulated Amortization Total Assets $333 1,789 4.115 56.237 Long-term Debt Common Stock Retained Earnings Total Liabilities and Shareholders Equity 55,636 2.392 3.244 $9.481 LIABILITIES AND SHAREHOLDERS' EQUITY Current Liabilities: Accounts Payable Notes Payable Accrued Liabilities Total Current Liabilities $473 1,850 1.298 53,621 2,363 2.250 1.247 59,481 Required: Using the information above, construct an pro forma Income Statement and cash budget for the six-month period (January to June 2022). Identify if there will be any need for short-term financing. Also, comment on the policy changes and potential consequences if the collection period had remained at 60 days. Assume capital assets are sufficient for increased sales. Bonus Mark Prepare a monthly pro forma Balance Sheet (for the six months June 2022). No accounts are effected other than those shown above. FORECASTING ASSIGNMENT - Mantly Inc. Assume you are the Financial Analyst for Mantly Inc., and it is January 1, 2022. Mantly Inc., a manufacturing company, has been growing quickly, but it has found that its financial situation is continually under pressure. Production has fluctuated to meet demand in an attempt to provide first-class service, resulting in larger inventory positions. Also, the collection of accounts has worsened to approximately 60 days, which is well above the invoice terms of net 30 days. To address the financial concerns, Mantly Inc. has proposed level production and an expected effort by the credit department to bring the average collection period down to 35 days. Estimated sales for the upcoming months are as follows: January 5978,750 February 1,035,000 March 1,102,500 April 1.181,250 May 1.237.500 June 1,282,500 Sales for November were $866,250 and will be approximately $922,500 for the just completed month of December. It is projected that the current collection period of 60 days will be reduced to 50 days for January and February and to 42 days for March and April, and will meet the target of 35 days in May and June. Inventory purchases are forecast to be $292,500 a month beginning in January. In November they were $337,500, and in December they are expected to be $303,750. The purchases are paid in 40 days. Manufacturing labour expense will be paid as incurred and will be $97,500 a month. Other expenses of manufacturing will also be paid as incurred and are expected to be $187,500 a month. Cost of goods sold has regularly been 70% of sales. Amortization is $19,000 per month. Selling and administrative expenses are expected to be 13 percent of sales (and also paid as incurred). The tax rate is 42 percent. There will be payments on Notes Payable of $337,500 in each of February and May. Income taxes of $169,000 are due in April. Dividends of $11,250 and interest of $135,000 (3 months of interest) are payable in January and April. Current Assets: Cash MANTLY INC. Balance Sheet (Estimated) December, 2021 (S thousands) ASSETS Accounts Receivable Inventory Total Current Assets Capital Assets: Plant and Equipment Less: Accumulated Amortization Total Assets $333 1,789 4.115 56.237 Long-term Debt Common Stock Retained Earnings Total Liabilities and Shareholders Equity 55,636 2.392 3.244 $9.481 LIABILITIES AND SHAREHOLDERS' EQUITY Current Liabilities: Accounts Payable Notes Payable Accrued Liabilities Total Current Liabilities $473 1,850 1.298 53,621 2,363 2.250 1.247 59,481 Required: Using the information above, construct an pro forma Income Statement and cash budget for the six-month period (January to June 2022). Identify if there will be any need for short-term financing. Also, comment on the policy changes and potential consequences if the collection period had remained at 60 days. Assume capital assets are sufficient for increased sales. Bonus Mark Prepare a monthly pro forma Balance Sheet (for the six months June 2022). No accounts are effected other than those shown above.
Expert Answer:
Answer rating: 100% (QA)
Pro Forma Income Statement for Mantly Inc January to June 2022 January February March April May June Total Sales 976751 1035000 1102500 1181250 123750... View the full answer
Related Book For
Corporate Finance
ISBN: 978-0077861759
10th edition
Authors: Stephen Ross, Randolph Westerfield, Jeffrey Jaffe
Posted Date:
Students also viewed these finance questions
-
You are the financial analyst for a tennis racket manufacturer. The company is considering using a graphite like material in its tennis rackets. The company has estimated the information in the...
-
You are the financial analyst for a tennis racket manufacturer. The company is considering using a graphite-like material in its tennis rackets. The company has estimated the information in the table...
-
You are the financial analyst for a tennis racket manufacturer. The company is considering using a graphite-like material in its tennis rackets. The company has estimated the information in the table...
-
Tell whether the given side lengths of a triangle can represent a right triangle. 36, 48, and 60
-
The Perry Preschool Project discussed in Exercises 10.39-10.41 found that 8 of the 58 students who attended preschool had at least one felony arrest by age 40 and that 31 of the 65 students who did...
-
What aspect of the inventory audit is mandatory?
-
Calculate the median for each of the following sets of data: a. 2, 2, 3, 4, 6, 9,9 b. 7, 7, 8, 12, 13, 14, 17, 21, 23 c. 11, 6, 3, 14, 12, 15, 8, 10, 7 d. 9, 6, 7, 5, 8, 7, 8, 9, 10, 8, 7 e. 10, 13,...
-
Your client, Manny Mendacious, invested $ 70,000 in the stock of a new start-up company that opened a chain of fried pickle fast-food restaurants call the Cooked Cucumber. As might be expected, this...
-
How do Agile scaling frameworks such as SAFe (Scaled Agile Framework) and LeSS (Large-Scale Scrum) address the complexities of coordinating multiple Agile teams within large enterprises, while...
-
(a) The steps in the accounting cycle for a merchandising company differ from the steps in the accounting cycle for a service company. Do you agree or disagree? (b) Is the measurement of net income...
-
Cruse Cleaning offers residential and small office cleaning services. An average cleaning service has the following price and costs. Sales price Variable costs Fixed costs $ 137.00 per service 99.00...
-
When you apply the brakes on your car, the kinetic energy of your vehicle is transformed into thermal energy in your brake disks. During a mountain descent, a 28.00-cm-diameter iron brake disk heats...
-
Humans can produce an output power as great as 20 W/kg during extreme exercise. Sloths are not so energetic. At its maximum speed, a 4.0 kg sloth can climb a height of 6.0 m in 2.0 min. Whats the...
-
The opposite of a wind turbine is an electric fan: The electric energy that powers the fan is converted to the kinetic energy of moving air. A fan is putting 1.0 J of kinetic energy into the air...
-
A typical meteor that hits the earths upper atmosphere has a mass of only 2.5 g, about the same as a penny, but it is moving at an impressive 40 km/s. As the meteor slows, the resulting thermal...
-
Most of the energy you expend in cycling is dissipated by the drag force. If you double your speed, you increase the drag force by a factor of 4. This increases the power to cycle at this greater...
-
Please help Gary earned \( \$ 97,000 \) as an executive. Gary, who is single, supported his half sister, who lives in a nursing home. His half sister had no income during the year. Gary received the...
-
What are some of the possible sources of information about a company that could be used for determining the companys competitive stance?
-
Consider the ratio EBITD/ Assets. What does this ratio tell us? Why might it be more useful than ROA in comparing two companies?
-
An option can often have more than one source of value. Consider a logging company. The company can log the timber today or wait another year (or more) to log the timber. What advantages would...
-
The market value balance sheet for Outbox Manufacturing is shown here. Outbox has declared a stock dividend of 25 percent. The stock goes ex-dividend tomorrow (the chronology for a stock dividend is...
-
What is the role of the origin of transfer during conjugation involving F+ and Hfr strains? What is the significance of the direction of transfer in Hfr conjugation?
-
What is the role of sex pili during conjugation?
-
Think about the structure and transmission of F factors, and discuss how you think F factors may have originated.
Study smarter with the SolutionInn App