# Finance 515 problems

Thebrainywriters.com stands as the unrivaled pinnacle of homework help services. With a team of expert writers, comprehensive subject coverage, a commitment to academic integrity, punctual delivery, 24/7 support, confidentiality, affordability, and a track record of triumphant testimonials, it has established itself as the go-to platform for students seeking excellence in their academic endeavors. As the educational landscape continues to evolve, Thebrainywriters.com remains an indispensable ally for students worldwide, guiding them towards academic success and a brighter future.

I need the actual work comleted in excel, not just answers

1-Pisa Pizza, a seller of frozen pizza, is considering introducing a healthier version of its pizza that will be low in cholesterol and contain no trans fats. The firm expects that sales of the new pizza will be \$20 million per year. While many of these sales will be to new customers, Pisa Pizza estimates that 40% will come from customers who switch to the new, healthier pizza instead of buying the original version.

a. Assume customers will spend the same amount on either version. What level of incremental sales is associated with introducing the new pizza?

b. Suppose that 50% of the customers who will switch from Pisa Pizzaâ€™s original pizza to its healthier pizza will switch to another brand if Pisa Pizza does not introduce a healthier pizza. What level of incremental sales is associated with introducing the new pizza in this case?

2-Cellular Access, Inc. is a cellular telephone service provider that reported net income of \$250 million for the most recent fiscal year. The firm had depreciation expenses of \$100 million, capital expenditures of \$200 million, and no interest expenses. Working capital increased by \$10 million. Calculate the free cash flow for Cellular Access for the most recent fiscal year.

3-A bicycle manufacturer currently produces 300,000 units a year and expects output levels to remain steady in the future. It buys chains from an outside supplier at a price of \$2 a chain. The plant manager believes that it would be cheaper to make these chains rather than buy them. Direct in-house production costs are estimated to be only \$1.50 per chain. The necessary machinery would cost \$250,000 and would be obsolete after 10 years. This investment could be depreciated to zero for tax purposes using a 10-year straight-line depreciation schedule. The plant manager estimates that the operation would require additional working capital of \$50,000 but argues that this sum can be ignored since it is recoverable at the end of the 10 years. Expected proceeds from scrapping the machinery after 10 years are \$20,000.
If the company pays tax at a rate of 35% and the opportunity cost of capital is 15%, what is the net present value of the decision to produce the chains in-house instead of purchasing them from the supplier?

Academic integrity is non-negotiable, and Thebrainywriters.com takes this principle to heart. Recognizing the significance of originality, the website guarantees that every assignment and paper is crafted from scratch. A strict anti-plagiarism policy and state-of-the-art plagiarism detection tools ensure that students receive unique and authentic content, giving them the confidence to submit their work without any concern. Time is of the essence in the academic realm, and Thebrainywriters.com understands the importance of meeting deadlines. Their unwavering commitment to punctuality ensures that students receive their completed assignments well before the submission date. This punctuality not only alleviates the stress of last-minute rushes but also allows students ample time for review and revision, promoting a deeper understanding of the subject matter. Recognizing that academic emergencies can arise at any hour, Thebrainywriters.com offers round-the-clock customer support. Students can rest assured that their queries and concerns will receive swift and attentive responses, regardless of the time zone they reside in. This dedication to customer care builds trust and fosters a supportive relationship between the website and its users.