GetMyFood, Inc. has developed an application for cell phones aimed toward consumers who live in more rural areas where there are few delivery options for take-out food. The app connects local taxi drivers with the larger restaurant food delivery services in nearby areas to extend the range of home meal delivery service.
The company expects to generate revenues of $2000 (figures in thousands) in the first year (2020) with a general costs of services sold of $1200 (figures in thousands.) The company expects to see a sharp increase in the revenues earned after the first year as the new service gains recognition but believes that the life-cycle of the product will be relatively short as market research has shown that the business model will be most successful in areas that are more rural but still relatively close to larger population centers. Given the general demographic trend in population growth, the company believes that their target market will diminish over time as more standard delivery services become available.
The company estimates the following growth rate for revenue, costs, and SG&A over the next five years:
|
Growth Rate for Selected Items |
||||||
|
2019 |
2020 |
2021 |
2022 |
2023 |
2024 |
|
|
Revenue Growth |
5% |
15% |
10% |
3% |
||
|
CGS |
3% |
4% |
2% |
2% |
||
|
SG&A (% of Revenue) |
28% |
27% |
26% |
24% |
20% |
|
The have also forecasted the following items for working capital:
|
Selected Projections (Figures in thousands) |
||||||
|
2019 |
2020 |
2021 |
2022 |
2023 |
2024 |
|
|
A/R |
300 |
325 |
310 |
295 |
250 |
|
|
A/P |
200 |
230 |
240 |
220 |
210 |
|
|
Inventory |
50 |
65 |
40 |
30 |
20 |
|
|
Depreciation |
100 |
113 |
117 |
104 |
115 |
|
Taxes are assumed to be 34% per year. The initial outlay for software development is estimated to be $1000.
You have been hired as a financial consultant to determine the estimated free cash flows to the firm for GetMyFood, Inc.
In: Finance
My teacher barely speaks English so your guess is as good as mine what he means. Also, this is all of the data that he gave the class and I have nothing else to share. Please don't tell me the information is misleading and or filled with typos, etc. I copied and paste what is being asked of us and that is why I am here, to get help. Please use the information that is provided to either help solve it or show me how and where the math won't work. Thank you.
Firm 3302 (name of firm)
2020. Dividends =3.23. risk free rate= 5.3%. market return = 4%. beta = 1.12
2020 Dividends =3.65. risk free rate= 6.3% market return =3.5% beta =1.22
2022. Dividends = 4.01 risk free rate= 5.2% market return = 4.2%. beta =1.02
2023 Dividends = 3.58 risk free rate= 4.2% market return =3% market return =1.32
2024 Dividends =2.01 risk free rate=3.9% market return =2% market return =1.25
This is our firm which is called 3302-firm expected dividend distribution table, we have many professional backups. Hence, based on us professional backups forecast, we 100% know that our dividend growth rate will be increasing in same rate after the last day of 2024. As we all know, between 2024 and infinite, we also learn that the ROE is 4% and reinvestment rate is 10%. The risk-free rate constantly equal to 4% and the market return constantly equals to 5%. Beta = 1.1. These number won’t change in the future. As we all know, between 2020 and 2024, we also learn that the ROE is 10.2% and reinvestment rate is 35%. All the numbers are listed on the table above. Question: Please find out 3302-firm’s intrinsic value today.
In: Finance
Two inventors, recently organized as Innovation, Inc., consult you regarding a planned new product.They have estimates of the costs of materials, labor, overhead, and other expenses for 2016 but need to know how much to charge for each unit to earn a profit in 2016 equal to 15% of their estimated total long-term investment of $560,000 (ignore income taxes).
Their plans indicate that each unit of the new product requires the following:
| Direct Material | 4 lb. of a material costing $7 per lb. |
| Direct labor | 2 hrs. of a metal former's time at $15.40 per hr. |
| 0.6 hr. of an assembler's time at $11.20 per hr. |
Major items of production overhead would be annual rent of $65,044 for a factory building, $40,124 rent for machinery, and $30,380 of indirect material. Other production overhead is estimated to be $326,592. Selling expenses are an estimated 30% of total sales, and non-factory administrative expenses are 20% of total sales.
The consensus at Innovation is that during 2016 10,000 units of
product should be produced for selling and another 2,000 units
should be produced for the next year's beginning inventory. Also,
an extra 3,000 pounds of material will be purchased as beginning
inventory for the next year. Because of the nature of the
manufacturing process, all units started must be completed, so work
in process inventories are negligible.
Required
a. Incorporate the above data into a schedule of estimated total
manufacturing costs and compute the unit production cost for
2016.
Do not use negative signs with any of your answers.
| Estimated Total Manufacturing Cost For the Year Ended December 31,2016 |
|||
|---|---|---|---|
| Direct material: | |||
| Beginning materials inventory | Answer | ||
| AnswerCost of materials purchasedEnding materials inventoryIndirect materials usedOther factory overhead | Answer | ||
| Cost of material available | Answer | ||
| Less: | AnswerCost of materials purchasedEnding materials inventoryIndirect materials usedOther factory overhead | Answer | |
| Total materials used | Answer | ||
| Less: | AnswerCost of materials purchasedEnding materials inventoryIndirect materials usedOther factory overhead | Answer | |
| Direct materials used | Answer | ||
| Direct labor | Answer | ||
| Manufacturing overhead | |||
| Indirect material | Answer | ||
| Building rent | Answer | ||
| Machinery rent | Answer | ||
| AnswerCost of materials purchasedEnding materials inventoryIndirect materials usedOther factory overhead | Answer | ||
| Total manufacturing overhead | Answer | ||
| Total manufacturing costs | Answer | ||
| Round answer to two decimal places. | |||
| Product cost per unit | Answer | ||
b. Prepare an estimated income statement that would provide the target amount of profit for 2016.
| Income Statement For the Year Ended December 31,2016 |
||
|---|---|---|
| AnswerCost of goods soldNet incomeAdministrative expensesSalesSelling expenses | Answer | |
| AnswerCost of goods soldNet incomeAdministrative expensesSalesSelling expenses | Answer | |
| Gross profit on sales | Answer | |
| Operating expenses: | ||
| AnswerCost of goods soldIndirect materialNet incomeSalesSelling expenses | Answer | |
| AnswerCost of goods soldNet incomeIndirect materialAdministrative expensesSales | Answer | Answer |
| AnswerCost of goods soldNet incomeAdministrative expensesSalesSelling expenses | Answer | |
c. What unit sales price should Innovation charge for the new product?
$Answer
In: Accounting
Ponpon produces cans of jelly. The company would like to purchase a canning machine. The machine costs $25,000 and the company needs a loan to make the purchase. Before agreeing to the loan, their bank requires Ponpon to provide both current (2020) and budgeted (3 months in 2021) financial statements.
Use the following information from Ponpon to provide the bankers with the 2021 budgeted financial states.
Balance Sheet
Cash $50,000
Accounts Receivable $31,000
Inventory $12,000
Fixed Assets $37,000
Total Assets $130,000
Accounts Payable $22,500
Accrued Credit Fees $9,200
Common Stock $46,800
Retained Earnings $$51,500
Total Liabilities & Equity $130,000
2021 Sales Forecast
January $74,000
February $82,000
March $58,000
April $54,000
May $80,000
June $67,000
July $70,500
Additional Info:
a. Ponpon only accepts credit cards when selling their jelly. Ponpon collects 35% of the sales on account in the month of the sale and 65% in the month after the sale.
b. Unfortunately, the credit card companies pass along a 6.2% sales fee to Ponpon for the convenience and safety of their transactions on account. The sales fee is due one month after the sale.
c. The cost of sales is 42% of (current month) sales.
d. Ponpon maintains an inventory at all times at the sales requirements (COS) for the months’ budgeted sales. This provides assurance that they won’t run out of jelly.
e. Ponpon uses a credit card for all their purchases. The company pays off their credit card balance in full the following month.
f. Ponpon pays 5% of sales each month to Jako Co. for the CEO’s security service.
g. In addition to the carriable security cost, Ponpon incurs fixed expenses of $22,000 per month, $1500 of which is for depreciation of fixed assets.
1. Prepare a budgeted Income Statement for the three-month period ending March 31, 2021 (Pro Forma Income Statement).
Pro Forma Income Statement:
For the period: January 1 - March 31, 2021
January February March Total
Sales
Cost of goods sold
Gross Margin
Less Expenses:
Variable Costs (mgmt fee)
Credit Card Fees
Fixed Expenses
Total Expenses
Net Income
In: Accounting
QualSupport Corporation manufactures seats for automobiles, vans, trucks, and various recreational vehicles. The company has a number of plants around the world, including the Denver Cover Plant, which makes seat covers.
Ted Vosilo is the plant manager of the Denver Cover Plant but also serves as the regional production manager for the company. His budget as the regional manager is charged to the Denver Cover Plant.
Vosilo has just heard that QualSupport has received a bid from an outside vendor to supply the equivalent of the entire annual output of the Denver Cover Plant for $22.26 million. Vosilo was astonished at the low outside bid because the budget for the Denver Cover Plant’s operating costs for the upcoming year was set at $25.56 million. If this bid is accepted, the Denver Cover Plant will be closed down.
The budget for Denver Cover’s operating costs for the coming year is presented below.
| Denver Cover Plant Annual Budget for Operating Costs |
|||||
| Materials | $ | 8,000,000 | |||
| Labor: | |||||
| Direct | $ | 7,300,000 | |||
| Supervision | 450,000 | ||||
| Indirect plant | 2,400,000 | 10,150,000 | |||
| Overhead: | |||||
| Depreciation—equipment | 1,700,000 | ||||
| Depreciation—building | 2,500,000 | ||||
| Pension expense | 1,200,000 | ||||
| Plant manager and staff | 510,000 | ||||
| Corporate expenses* | 1,500,000 | 7,410,000 | |||
| Total budgeted costs | $ | 25,560,000 | |||
*Fixed corporate expenses allocated to plants and other operating units based on total budgeted wage and salary costs.
Additional facts regarding the plant’s operations are as follows:
Required:
1. QualSupport Corporation plans to prepare a financial analysis that will be used in deciding whether or not to close the Denver Cover Plant. Management has asked you to identify:
a. The annual budgeted costs that are relevant to the decision regarding closing the plant.
b. The annual budgeted costs that are not relevant to the decision regarding closing the plant.
c. Any nonrecurring costs that would arise due to the closing of the plant.
d. Looking at the data you have prepared in (2) above,
e. Calculate the financial advantage (disadvantage) of closing the plant.
f. Should the plant be closed?
In: Accounting
QualSupport Corporation manufactures seats for automobiles, vans, trucks, and various recreational vehicles. The company has a number of plants around the world, including the Denver Cover Plant, which makes seat covers.
Ted Vosilo is the plant manager of the Denver Cover Plant but also serves as the regional production manager for the company. His budget as the regional manager is charged to the Denver Cover Plant.
Vosilo has just heard that QualSupport has received a bid from an outside vendor to supply the equivalent of the entire annual output of the Denver Cover Plant for $22.88 million. Vosilo was astonished at the low outside bid because the budget for the Denver Cover Plant’s operating costs for the upcoming year was set at $26.18 million. If this bid is accepted, the Denver Cover Plant will be closed down.
The budget for Denver Cover’s operating costs for the coming year is presented below.
|
Denver Cover Plant Annual Budget for Operating Costs |
|||||
| Materials | $ | 8,400,000 | |||
| Labor: | |||||
| Direct | $ | 7,600,000 | |||
| Supervision | 490,000 | ||||
| Indirect plant | 1,400,000 | 9,490,000 | |||
| Overhead: | |||||
| Depreciation—equipment | 1,700,000 | ||||
| Depreciation—building | 3,100,000 | ||||
| Pension expense | 1,800,000 | ||||
| Plant manager and staff | 590,000 | ||||
| Corporate expenses* | 1,100,000 | 8,290,000 | |||
| Total budgeted costs | $ | 26,180,000 | |||
*Fixed corporate expenses allocated to plants and other operating units based on total budgeted wage and salary costs.
Additional facts regarding the plant’s operations are as follows:
Required:
2. QualSupport Corporation plans to prepare a financial analysis that will be used in deciding whether or not to close the Denver Cover Plant. Management has asked you to identify:
a. The annual budgeted costs that are relevant to the decision regarding closing the plant.
b. The annual budgeted costs that are not relevant to the decision regarding closing the plant.
c. Any nonrecurring costs that would arise due to the closing of the plant.
3. Looking at the data you have prepared in (2) above,
a. Calculate the financial advantage (disadvantage) of closing the plant.
b. Should the plant be closed?
In: Accounting
QualSupport Corporation manufactures seats for automobiles, vans, trucks, and various recreational vehicles. The company has a number of plants around the world, including the Denver Cover Plant, which makes seat covers.
Ted Vosilo is the plant manager of the Denver Cover Plant but also serves as the regional production manager for the company. His budget as the regional manager is charged to the Denver Cover Plant.
Vosilo has just heard that QualSupport has received a bid from an outside vendor to supply the equivalent of the entire annual output of the Denver Cover Plant for $21.77 million. Vosilo was astonished at the low outside bid because the budget for the Denver Cover Plant’s operating costs for the upcoming year was set at $25.07 million. If this bid is accepted, the Denver Cover Plant will be closed down.
The budget for Denver Cover’s operating costs for the coming year is presented below.
| Denver Cover Plant Annual Budget for Operating Costs |
|||||
| Materials | $ | 8,600,000 | |||
| Labor: | |||||
| Direct | $ | 6,100,000 | |||
| Supervision | 410,000 | ||||
| Indirect plant | 1,800,000 | 8,310,000 | |||
| Overhead: | |||||
| Depreciation—equipment | 1,900,000 | ||||
| Depreciation—building | 2,400,000 | ||||
| Pension expense | 1,800,000 | ||||
| Plant manager and staff | 660,000 | ||||
| Corporate expenses* | 1,400,000 | 8,160,000 | |||
| Total budgeted costs | $ | 25,070,000 | |||
*Fixed corporate expenses allocated to plants and other operating units based on total budgeted wage and salary costs.
Additional facts regarding the plant’s operations are as follows:
Required:
2. QualSupport Corporation plans to prepare a financial analysis that will be used in deciding whether or not to close the Denver Cover Plant. Management has asked you to identify:
a. The annual budgeted costs that are relevant to the decision regarding closing the plant.
b. The annual budgeted costs that are not relevant to the decision regarding closing the plant.
c. Any nonrecurring costs that would arise due to the closing of the plant.
3. Looking at the data you have prepared in (2) above,
a. Calculate the financial advantage (disadvantage) of closing the plant.
b. Should the plant be closed?
In: Accounting
QualSupport Corporation manufactures seats for automobiles, vans, trucks, and various recreational vehicles. The company has a number of plants around the world, including the Denver Cover Plant, which makes seat covers.
Ted Vosilo is the plant manager of the Denver Cover Plant but also serves as the regional production manager for the company. His budget as the regional manager is charged to the Denver Cover Plant.
Vosilo has just heard that QualSupport has received a bid from an outside vendor to supply the equivalent of the entire annual output of the Denver Cover Plant for $20.75 million. Vosilo was astonished at the low outside bid because the budget for the Denver Cover Plant’s operating costs for the upcoming year was set at $24.05 million. If this bid is accepted, the Denver Cover Plant will be closed down.
The budget for Denver Cover’s operating costs for the coming year is presented below.
| Denver Cover Plant Annual Budget for Operating Costs |
|||||
| Materials | $ | 8,600,000 | |||
| Labor: | |||||
| Direct | $ | 6,600,000 | |||
| Supervision | 380,000 | ||||
| Indirect plant | 1,500,000 | 8,480,000 | |||
| Overhead: | |||||
| Depreciation—equipment | 1,000,000 | ||||
| Depreciation—building | 2,600,000 | ||||
| Pension expense | 1,800,000 | ||||
| Plant manager and staff | 570,000 | ||||
| Corporate expenses* | 1,000,000 | 6,970,000 | |||
| Total budgeted costs | $ | 24,050,000 | |||
*Fixed corporate expenses allocated to plants and other operating units based on total budgeted wage and salary costs.
Additional facts regarding the plant’s operations are as follows:
Required:
2. QualSupport Corporation plans to prepare a financial analysis that will be used in deciding whether or not to close the Denver Cover Plant. Management has asked you to identify:
a. The annual budgeted costs that are relevant to the decision regarding closing the plant.
b. The annual budgeted costs that are not relevant to the decision regarding closing the plant.
c. Any nonrecurring costs that would arise due to the closing of the plant.
3. Looking at the data you have prepared in (2) above,
a. Calculate the financial advantage (disadvantage) of closing the plant.
b. Should the plant be closed?
In: Accounting
QualSupport Corporation manufactures seats for automobiles, vans, trucks, and various recreational vehicles. The company has a number of plants around the world, including the Denver Cover Plant, which makes seat covers.
Ted Vosilo is the plant manager of the Denver Cover Plant but also serves as the regional production manager for the company. His budget as the regional manager is charged to the Denver Cover Plant.
Vosilo has just heard that QualSupport has received a bid from an outside vendor to supply the equivalent of the entire annual output of the Denver Cover Plant for $23.09 million. Vosilo was astonished at the low outside bid because the budget for the Denver Cover Plant’s operating costs for the upcoming year was set at $26.39 million. If this bid is accepted, the Denver Cover Plant will be closed down.
The budget for Denver Cover’s operating costs for the coming year is presented below.
| Denver Cover Plant Annual Budget for Operating Costs |
|||||
| Materials | $ | 9,000,000 | |||
| Labor: | |||||
| Direct | $ | 7,500,000 | |||
| Supervision | 470,000 | ||||
| Indirect plant | 1,500,000 | 9,470,000 | |||
| Overhead: | |||||
| Depreciation—equipment | 1,800,000 | ||||
| Depreciation—building | 2,900,000 | ||||
| Pension expense | 1,700,000 | ||||
| Plant manager and staff | 520,000 | ||||
| Corporate expenses* | 1,000,000 | 7,920,000 | |||
| Total budgeted costs | $ | 26,390,000 | |||
*Fixed corporate expenses allocated to plants and other operating units based on total budgeted wage and salary costs.
Additional facts regarding the plant’s operations are as follows:
Required:
2. QualSupport Corporation plans to prepare a financial analysis that will be used in deciding whether or not to close the Denver Cover Plant. Management has asked you to identify:
a. The annual budgeted costs that are relevant to the decision regarding closing the plant.
b. The annual budgeted costs that are not relevant to the decision regarding closing the plant.
c. Any nonrecurring costs that would arise due to the closing of the plant.
3. Looking at the data you have prepared in (2) above,
a. Calculate the financial advantage (disadvantage) of closing the plant.
b. Should the plant be closed?
In: Accounting
QualSupport Corporation manufactures seats for automobiles, vans, trucks, and various recreational vehicles. The company has a number of plants around the world, including the Denver Cover Plant, which makes seat covers.
Ted Vosilo is the plant manager of the Denver Cover Plant but also serves as the regional production manager for the company. His budget as the regional manager is charged to the Denver Cover Plant.
Vosilo has just heard that QualSupport has received a bid from an outside vendor to supply the equivalent of the entire annual output of the Denver Cover Plant for $18.58 million. Vosilo was astonished at the low outside bid because the budget for the Denver Cover Plant’s operating costs for the upcoming year was set at $21.88 million. If this bid is accepted, the Denver Cover Plant will be closed down.
The budget for Denver Cover’s operating costs for the coming year is presented below.
| Denver Cover Plant Annual Budget for Operating Costs |
|||||
| Materials | $ | 7,600,000 | |||
| Labor: | |||||
| Direct | $ | 6,400,000 | |||
| Supervision | 430,000 | ||||
| Indirect plant | 2,000,000 | 8,830,000 | |||
| Overhead: | |||||
| Depreciation—equipment | 1,100,000 | ||||
| Depreciation—building | 1,300,000 | ||||
| Pension expense | 1,300,000 | ||||
| Plant manager and staff | 550,000 | ||||
| Corporate expenses* | 1,200,000 | 5,450,000 | |||
| Total budgeted costs | $ | 21,880,000 | |||
*Fixed corporate expenses allocated to plants and other operating units based on total budgeted wage and salary costs.
Additional facts regarding the plant’s operations are as follows:
Required:
2. QualSupport Corporation plans to prepare a financial analysis that will be used in deciding whether or not to close the Denver Cover Plant. Management has asked you to identify:
a. The annual budgeted costs that are relevant to the decision regarding closing the plant.
b. The annual budgeted costs that are not relevant to the decision regarding closing the plant.
c. Any nonrecurring costs that would arise due to the closing of the plant.
3. Looking at the data you have prepared in (2) above,
a. Calculate the financial advantage (disadvantage) of closing the plant.
b. Should the plant be closed?
In: Accounting