Reference no: EM133125111
Question - 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
|
$978,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.
|
MANTLY INC. Balance Sheet (Estimated) December, 2021 ($ thousands)
|
|
ASSETS
|
|
Current Assets:
|
|
|
Cash
|
|
$333
|
|
Accounts Receivable
|
|
1,789
|
|
Inventory
|
|
4,115
|
|
Total Current Assets
|
|
$6,237
|
|
Capital Assets:
|
|
|
|
Plant and Equipment
|
$5,636
|
|
|
Less: Accumulated Amortization
|
2,392
|
3,244
|
|
Total Assets
|
|
$9,481
|
|
|
|
|
LIABILITIES AND SHAREHOLDERS' EQUITY
|
|
Current Liabilities:
|
|
|
|
Accounts Payable
|
|
$473
|
|
Notes Payable
|
|
1,850
|
|
Accrued Liabilities
|
|
1,298
|
|
Total Current Liabilities
|
|
$3,621
|
|
Long-term Debt
|
|
2,363
|
|
Common Stock
|
|
2,250
|
|
Retained Earnings
|
|
1,247
|
|
Total Liabilities and Shareholders' Equity
|
|
$9,481
|
Required -
1. Construct a 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.
2. Prepare a monthly pro forma Balance Sheet (for the six months June 2022). No accounts are effected other than those shown above.
|
Develop an appropriate research question
: Imagine you were studying the trade war with China through a micro-economic lens. Develop an appropriate research question.
|
|
Find the change in factor prices
: Suppose that a firm has a budget of $30,000, that the wage rate is $10 per hour, and that the rental rate of capital is $100 per hour. If the wage rate increase
|
|
Why is knowledge important for decision makers
: A) Draw the business cycle and explain what happens to Aggregate Expenditure, production, unemployment and GDP, at each stage of the business cycle?
|
|
Which amongst all of the moe option
: Which amongst all of the MOE options (Exporting, Joint Venture, Turnkey, Wholly Owned Subsidiary, Licensing agreement, Franchising) are easy to change and which
|
|
Construct a pro forma Income Statement and cash budget
: Construct a pro forma Income Statement and cash budget for the six-month period (January to June 2022)
|
|
Government embargoes exporting of face
: In the context of covid-lB, explain the reasons why Thailand government embargoes exporting of face masks and also intervenes the retail price of 3-ply masks in
|
|
Different regions of the country
: Sarah and Alice live and work in different regions of the same country.
|
|
Create the conditions for capitalist competition
: 2. Using a historical instance as an example, explain how the State helped to create the conditions for capitalist competition.
|
|
Name some of the health benefits
: Name some of the health benefits of social connection described in the video tedx connect or die - the surprising power of human relationships?
|