Question

In: Finance

Please do on excel and screenshot with formulas. You are examining the desirability of selling widgets....

Please do on excel and screenshot with formulas.

You are examining the desirability of selling widgets. To conduct the analysis, you’ve estimated that you will sell 1 million units and will sell the units for $99 each for the next five years. The variable costs for producing this product is estimated to be $32 per unit. Fixed costs will be $3 million per year. The equipment used to produce the widgets will cost $20 million and will be depreciated using the MACRS depreciation schedule for a five-year useful life. In year 5, the equipment will be sold for 20% of its original cost. The tax rate is 21%. Construct a proforma income statement to find the net income and operating cash flow for each of the five years of the project.

Solutions

Expert Solution

Formula:


Related Solutions

you are examining the desirability of selling widgets. To conduct the analysis, you’ve estimated that you...
you are examining the desirability of selling widgets. To conduct the analysis, you’ve estimated that you will sell 1 million units and will sell the units for $99 each for the next five years. The variable costs for producing this product is estimated to be $23 per unit. Fixed costs will be $5 million per year. The equipment used to produce the widgets will cost $30 million and will be depreciated using the MACRS depreciation schedule for a five-year useful...
1. You are examining the desirability of selling widgets. To conduct the analysis, you’ve estimated that...
1. You are examining the desirability of selling widgets. To conduct the analysis, you’ve estimated that you will sell 1 million units and will sell the units for $99 each for the next five years. The variable costs for producing this product is estimated to be $32 per unit. Fixed costs will be $3 million per year. The equipment used to produce the widgets will cost $20 million and will be depreciated using the MACRS depreciation schedule for a five-year...
Kindly do on excel and screenshot with formulas. 1. You are ready to buy a house...
Kindly do on excel and screenshot with formulas. 1. You are ready to buy a house and you have $50,000 for a down payment and closing costs. Closing costs are estimated to be 3.5% of the loan value. You have an annual salary of $200,000. The bank is willing to allow your housing costs – mortgage, property tax, and homeowners insurance to be equal to 28% of your monthly income. You have estimated that property tax will be $1,000/month and...
PLEASE UPLOAD EXCEL FILE OR A SCREENSHOT SHOWING FORMULAS Must be submitted in excel with any...
PLEASE UPLOAD EXCEL FILE OR A SCREENSHOT SHOWING FORMULAS Must be submitted in excel with any math done with formulas within cells. The Jackpots Dreams Cards Company is a card manufacturer. All direct materials and conversion costs are applied to all of Proball Trading Cards’ products at an even rate throughout the manufacturing process. For August, the beginning work in process inventory for the Finishing Department was 9,600 units that averaged 65 percent complete. Ending work in process inventory was...
PLEASE UPLOAD EXCEL FILE OR A SCREENSHOT SHOWING FORMULAS Must be submitted in excel with any...
PLEASE UPLOAD EXCEL FILE OR A SCREENSHOT SHOWING FORMULAS Must be submitted in excel with any math done with formulas within cells. Electric Car Co (ECC). currently manufactures two different types of fully electronic cars in 2021. Type 8Y is a large SUV whereas Type 8W will be the fastest car in the world with 10 rocket thrusters. ECC has decided to use ABC costing instead of traditional costing. The 2021 budget to manufacture these new types include manufacturing overhead...
Can you do in excel please and show the formulas Lunar Motivation Corporation Income Statement ($...
Can you do in excel please and show the formulas Lunar Motivation Corporation Income Statement ($ in millions)                                                                                     2019                                                                Sales                          8000                                                                             Cost of Goods           -5600                                                  SGA                           -1500                                                  Interest                        -100                                                  EBT                              800                                                  Taxes (40%)               -320                                                  Net income                   480                                                  Dividends                    -100                                                  Retained earnings        380                                                                                     ====                                                                                                                                                              Lunar Motivation Corporation Balance Sheet                                                2019                                                                          2019                  Cash                                         10                                     Accounts payable        300   Accounts receivables             400                                     Notes payable              300   Inventory                                560                                     Current liabilities          600   Short term Investments            30                                     Long-term debt          1000   Current assets                     1000                                     Common stock             400   Net plant & equip.                3000                                     Retained earnings      2000   Total assets                         4000                                     Total liab. & equity     4000                                               =====                                                                      =====                              You have forecasted Lunar Motivation Corporation (LMC) free cash flow in 2020 to be...
Please use excel then show the formula. and screenshot 6. Assume that you want to buy...
Please use excel then show the formula. and screenshot 6. Assume that you want to buy a home. You find a home for which you will owe $140,000 after paying the down payment. Assume that you are able to get a 5% mortgage loan for 30 years. Payments are made monthly in arrears (at the end of the month). At the end of the 30 years, you will have paid off the entire loan. A) How much will your monthly...
Can you do in excel please and show Formulas The Air Marshal Co. has recently completed...
Can you do in excel please and show Formulas The Air Marshal Co. has recently completed a $10,000,000 two-year marketing study.  Based on the results of this study, Air Marshal has estimated that 800 units of its new security electro-optical human scanning hardware, known as "Marshal Dillon," could be sold annually over the next 12 years, at a price of $110,000 the first year with an estimated 2% annual rise from inflation in years 2-6.  The sales price is expected to drop...
Can you do in excel please and show Formulas The Air Marshal Co. has recently completed...
Can you do in excel please and show Formulas The Air Marshal Co. has recently completed a $10,000,000 two-year marketing study.  Based on the results of this study, Air Marshal has estimated that 800 units of its new security electro-optical human scanning hardware, known as "Marshal Dillon," could be sold annually over the next 12 years, at a price of $110,000 the first year with an estimated 2% annual rise from inflation in years 2-6.  The sales price is expected to drop...
PLEASE ANSWER USING EXCEL. please show formulas used in excel. THANK YOU :) Parry Enterprises sells...
PLEASE ANSWER USING EXCEL. please show formulas used in excel. THANK YOU :) Parry Enterprises sells copy paper by the case to office supply stores. Each case of paper costs Parry $15. The operating costs are $30,000 per period. Each period, Parry sells approximately 15,000 cases of copy paper at $35 per case. Texas Office Emporium is requesting an order of 4,000 cases of copy paper in the next period at a price of $25 per case. Since Parry has...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT