Question
Offered Price \$40.00

# Finance Homework

Question # 00022481
Subject: Accounting
Due on: 08/09/2014
Posted On: 08/08/2014 07:05 PM

Rating:
4.1/5
Posted By
Questions:
1
Tutorials:
0
Feedback Score:

Question
Awesome Gadget, INC is considering making an additional investment in its production capabilities. It has collected data on the past year's (year 0) revenue, costs and quantity sold. Future Sales quantities are forecasted to be as shown in the data block below.
The price per unit will be increased \$2.50 annually (year-1 unit price = year-0 unit price + \$2.50, year-2 price = Year-1 price + \$2.50, etc.)
COGS per unit produced is forecast to decrease 5% annually (cost per unit in year-1 to be 5% less than the year-0 unit cost, year-2 unit cost will be 5% less than year-1, etc.)
Fixed cost (S.G. & A.) excluding depreciation will be constant for all years. Depreciation for each year is to be as shown in the data block (does not have to be calculated).
Using this data, prepare a three year proposal income statement (only) for years 1-3 using items from the following data block as needed. The income statement must be in the standard accounting sequence and format with appropriate totals.

Q2
 An investment committee has narrowed down their investment decision to three proposals. Further information was collected on these three proposals and the investment amounts, estimated annual cash flows, and estimated salvage values are shown below. A MARR of 15% and a six year time-span is to be used. The committee only uses the IRR criterion. Determine which one maximizes the financial worth of the company usingthe internal rate of return criterion.

Q3
 Customers-R-Us,INC is considering a \$5 million investment that will have a useful life of 8 years, and sold in the eighth year for \$750,000. It will be depreciated using 10-year MACRS (table is below). a Determine the depreciation for each year of the eight year life of the investment b Determine the book value at the end of the eight years. c Determine the capital gain or loss when sold in the eighth year. d If the capital gain tax rate is 10%, what will be the capital gains tax?

Q4
Awesome Gadget, Inc. is considering a new expanded nation-wide marketing program. A proposal income statement and some additional data are shown below. (The figures are in thousands of dollars, but this need not be part of the calculations as it will not make any difference in the conclusion.)
This proposal does not require any assets that can be depreciated. Assume that the proposed \$3,000 marketing program is all S.G.&A. expense and includes all additional the S.G. & A. expenses needed for the marketing program.
Accounts receivable is forecasted to be 30% of revenue in each year starting with year 1. Finished Inventory is forecast at 10% of revenue also starting in year 1.
Accounts Payable is forecast to be \$1,000 in year 0 and 20% of the cost of goods sold in each year after year 0. Materials inventory is forecasted at \$1,500 in year 0 and 15% of the cost of goods sold in the years after year 0.
Prepare a cash flow statement and determine the present worth.

Q5
 Medical Miracles, INC. (MMI), a medical products distributor, is considering a proposal to establish an R&D group to study and recommend product innovations. They have a close association with customers and suspect that this offers them knowledge for improving products and for new products. The R&D group would add \$500,000 in S.G.& A. expenses annually that is not depreciable. The R&D group would patent their developments and contract others to build them. The proposal suggests that the cost of the new R&D group be covered by a 3% price increase in all products. It is further forecasted that this price increase would result in an immediate loss of 10% of sales revenues in year-1 from the year-0 level. Starting in year 2, it is forecast that the product innovations would result in year-over-year revenue increases as shown in row 10 below: If the proposed changes are not implemented, revenues are expected to stay constant at the year 0 level. COGS is 63% of revenue. S,G. & A. is presently \$5 million annually and would not change if the proposal is not implemented. Total Working capital is forecasted at 25% of revenue. There would be zero annual working capital change if the proposal is not implemented. Determine if the proposal is financially justified using the following data and a 5-year time span.

Q6
 Smart Phone, Inc. (SPI) has found that annual increases in its sales have diminished to near zero (Note that this is the increases in sales that are near zero, not the actual sales). To get growth started again, it has been proposed to offer a "Not-so-smart" phone model. It would be priced at 60% of the current "Smart" model. The new phone would not have a camera, GPS capabilities and other capabilities that require special hardware/chips. It simply would be a good user-friendly wireless telephone. A market research study determined that there indeed was a market for such a phone as a substantial number of users only use the telepone capibiltiies. It would be made to look much like the "Smart" version so people would not know which phone others were using. The downside is that it would result in a decrease in demand for the present "Smart" model. Depreciation averages \$600,000 annually (some assets bought, some sold) and this is not expected to change due to the proposal. If the "not-so-smart" phone was added, S.G.& A. would increase by \$3,000,000 annually. The cost to develop and introduce the 'Not-so-Smart" model would be \$20 million in year 0. This is not depreciable as no additional assets will be needed to produce the new phone. Determine if the \$20 million investment is financially justified using a 3-year time span.

Q7
 Two alternative replacement machines are described below that are being considered to replace a current one that has no salvage value. The present machine must be replaced and the replacement will not have any effect on quantity produced or sold, revenue, or S.G.& A. (except depreciation). The cost of the replacement machine will be depreciated using 5-year MACRS. The project evaluation time span should be 6 years. Machine A, while less expensive, only has a life span of 3 years Therefore it will have to be replaced at the end of year 3. Therefore its investment will be incurred both in year 0 and in year 3. Its salvage value will be received when replaced. Machine B is more expensive but will last 6 years and has a lower annual operating costs. All cost information is listed below. Performa a financial analysis to compare the alternatives.

Q8
 Below is an Income and cash flow statements for a new product model that management has approved. (If there are errors or oversights, that is their problem, not yours). Both question parts a and b should start from the original data. The cells with a green background contain the original values and are shown only to assist you in reverting back to the original values if needed. a Note that the present worth is negative. Determine the Investment amount that would achieve the MARR. Describe how you determined this. b What would be the present worth if the price was increased to \$37.99 in all years and this resulted in a 5% decline in the "Sales Quantity Forecast". (note that years 2-6 are all linked to year 1). Describe how you determined this.

Q9
 Below is an Income and cash flow statements for a new product model that management has approved. Two scenarios besides the original forecast are listed below along with the probability of each occurring. The model uses links to the Original forecast only. a Determine the expected worth and expected internal rate of return for the three scenarios. b Write a sentence or two recommendation to management concerning the answer to part a.

Q10
 The concepts of Benefit/Cost analysis and Cost effectiveness analysis have been highly touted as the primary financial analysis tools of the public sector. These tools can also be applied to the private sector especially for internal financial analysis decisions. Provide an example of how you would use each of these concepts in the public and private sectors. Limit your response to 75 words for each of the four examples. You can use a separate word document.
Attachments
Tutorials for this Question
Available for
\$50.00

#### Finance Homework

Tutorial # 00021813
Posted On: 08/08/2014 07:40 PM
Posted By:
mac123
Questions:
4669
Tutorials:
6272
Feedback Score:
Tutorial Preview ……
* - Additional Paypal / Transaction Handling Fee (3.9% of Tutorial price + \$0.30) applicable
Available for
\$25.00

#### Finance Homework

Tutorial # 00021825
Posted On: 08/08/2014 10:22 PM
Posted By:
neil2103
Questions:
9345
Tutorials:
13664
Feedback Score:
Tutorial Preview ……
* - Additional Paypal / Transaction Handling Fee (3.9% of Tutorial price + \$0.30) applicable
Available for
\$45.00

#### Finance exam solution all 10 questions

Tutorial # 00021887
Posted On: 08/09/2014 06:56 PM
Posted By:
neil2103
Questions:
9345
Tutorials:
13664
Feedback Score:
Tutorial Preview …solution xxx…
Attachments
Questions-1-10.xlsx (56.48 KB)
Preview: growth xxxxxxx again, xx has been xxxxxxxx to offer x "Not-so-smart" xxxxx xxxxx It xxxxx be priced xx 60% of xxx current xxxxxxx xxxxx The xxx phone would xxx have a xxxxxxx GPS xxxxxxxxxxxx xxx other xxxxxxxxxxxx that require xxxxxxx hardware/chips It xxxxxx would xx x good xxxxxxxxxxxxx wireless telephone x market research xxxxx determined xxxx xxxxx indeed xxx a market xxx such a xxxxx as x xxxxxxxxxxx number xx users only xxx the telepone xxxxxxxxxxxx It xxxxx xx made xx look much xxxx the "Smart" xxxxxxx so xxxxxx xxxxx not xxxx which phone xxxxxx were using xxx downside xx xxxx it xxxxx result in x decrease in xxxxxx for xxx xxxxxxx "Smart" xxxxx Determine if xxx \$20 million xxxxxxxxxx is xxxxxxxxxxx xxxxxxxxx using x 3-year time xxxx The cost xx develop xxx xxxxxxxxx the xxxxxxxxxxxxxx model would xx \$20 million xx year x xxxx is xxx depreciable as xx additional assets xxxx be xxxxxx xx produce xxx new phone xxxxx is an xxxxxx and xxxx xxxx statements xxx a new xxxxxxx model that xxxxxxxxxx has xxxxxxxx xxx there xxx errors or xxxxxxxxxxx that is xxxxx problem, xxx xxxxxx Both xxxxxxxx parts a xxx b should xxxxx from xxx xxxxxxxx data xxx cells with x green background xxxxxxx the xxxxxxxx xxxxxx and xxx shown only xx assist you xx reverting xxxx xx the xxxxxxxx values if xxxxxx What would xx the xxxxxxx xxxxx if xxx price was xxxxxxxxx to \$37 xx in xxx xxxxx and xxxx resulted in x 5% decline xx the xxxxxx xxxxxxxx Forecast" xxxxx that years xxx are all xxxxxx to xxxx xx Describe xxx you determined xxxx Determine the xxxxxxxx worth xxx xxxxxxxx internal xxxx of return xxx the three xxxxxxxxx Below xx xx Income xxx cash flow xxxxxxxxxx for a xxx product xxxxx xxxx management xxx approved Two xxxxxxxxx besides the xxxxxxxx forecast xxx xxxxxx below xxxxx with the xxxxxxxxxxx of each xxxxxxxxx The xxxxx xxxx links xx the Original xxxxxxxx only Question x (same xxxxx xx in xx with some xxxx changes and xxxxxxxxxxxx investment xxxxx xxx narrowed xxxx their investment xxxxxxxx to three xxxxxxxxxxxxx Further xxxxxxxxxxx xxx collected xx these three xxxxxxxxx and the xxxxxxxxxx amounts, xxxxxxxxx xxxxxx cash xxxxxx and estimated xxxxxxx values are xxxxxxxx below x xxxx of xxx and a xxx year time-frame xx to xx xxxx The xxxxxxxxx only uses xxx IRR criterion xxx : xxxx xxxx where xxxxxx equals outflow xxxxxx the better xxxxxxxxxxxxxxxx 6 xxxxxxxxxxxx xxxxxxxxxxxxxxxxxxxx = xx Of inflow1750000 xxxxxxxxxxxxx + 510000/(1+r)^2 x 510000/(1+r)^3 x xxxxxxxxxxxxxx + xxxxxxxxxxxxxx + 510000/(1+r)^6 x 80000/(1+r)^6(TRIAL AND xxxxx METHOD)Lets xxxxxx x = xx %So inflow xxxxx assume r x 18 xxx x = xxxx =20-18r =IRR xxxxxxxx =480000/(1+r) +.....
Q8-sol.xlsx (24.88 KB)
Preview: is xxxx than xxxxx Present worth xx negative So xx Investment xx xxxx than xxxxxxxxx then NPV xxxx be positive xxxxxxx Investment xx xxxx subject xx Depreciation So xxxxxx Invextment will xx much xxxxxx xxxxxxx Worth x NPV(MARR,CF1:CF6) + xxxxx Present worth x b x xx change xxxx price pu xx \$37 992 xxxxxx Sales xxxxxxxx xxx a xxxxxxx of 5% xx We reduced xxxxxxxxx.....
* - Additional Paypal / Transaction Handling Fee (3.9% of Tutorial price + \$0.30) applicable