User Account

All Pages

Request for quote, finance, Other Engineering

Assignment Help:
I need the following corporate finance problems completed in an excel spreadsheet. How much would this cost?
1) An investment project requires a net investment of $100,000. The project is expected to generate annual net cash flows of $28,000 for the next 5 years. The firm''s cost of capital is 12%. Part 1 - Determine the payback period for the project. Part 2 – Determine the payback period accounting for the present value of future cash flow (ie. Present value calculations). Should the project be done? After considering present value is the 100,000 investment recovered in 3-4 years, 4-5 years or over 5 years?





2) What is the IRR for a project that has a net investment of $14,600 and a single net cash flow of $25,750 in 5 years?





3) Red Lake Mines, Inc. is considering adoption of a new project requiring a net investment of $10 million. The project is expected to generate 5 years of net cash inflows of $5 million per year. In the project''s sixth, and final, year it is expected to have a net cash outflow of $1 million. What is the project NPV, using a discount rate of 12%?




4) Zimmer, a manufacturer of modular rooms, plans to expand its operations in Landshut, Germany. The expansion will cost $14.5 million and is expected to generate annual net cash flows of €2.15 million for a period of 12 years and then the operation will be sold for €1 million (net of taxes). The cost of capital for the project is 14%. Using a spot exchange rate of $1.25/€ as the forecast FX rate for the euro for the term of the project, compute the NPV of this expansion project.






5) Dupree Funds is considering the fees charged by two banks. First America charges a flat rate of $0.11 per payment and First Western requires a deposit of $500,000 (that does not pay interest to Dupree), plus $.05 per payment. What is the number of payments per year where the costs of the two banks will be equal? Assume Dupree''s cost of funds is 9%.









6) What is the annual tax shield to a firm that has total assets of $80 million and a net worth of $55 million, if the average interest rate on debt is 8.5% and the marginal tax rate is 35%?







7) Jason is interested in finding the breakeven point for a new pump it plans to produce. The price of the pump is $250 and the variable cost ratio is 50% of the price. Jason calculated that the fixed costs will be about $400,000. What is the breakeven point of operations?













8) Crown Honda purchased one of its most popular motorcycle models for 965,000 yen. The FX rate for the yen was 142 yen per dollar at the time of purchase, but then rose to 171.8 yen by the time payment was made. What was the dealer’s gain or loss on the change in rates?









9) Seduak has estimated the costs of debt and equity capital for various proportions of debt in its capital structure.

% Debt After-tax cost of debt Cost of equity
0% - 13.0%
10 5.4% 13.3
20 5.4 13.8
30 5.8 14.4
40 6.3 15.2
50 7.0 16.0
60 8.2 17.0

Based on these estimates, determine Seduak’s optimal capital structure

Related Discussions:- Request for quote, finance

Identify fire hazards - fire risk assessment , Identify fire hazards: ...

Identify fire hazards: In this part, the process appears to be concentrating on issues that can lead to fire but we have to remember to also consider the presence of a fire wi

Radar systems, Radar Systems Radar is an acronym for RAdio Detection...

Radar Systems Radar is an acronym for RAdio Detection And Ranging.  A radar uses an antenna to transmit a series of electromagnetic waves or pulses, and an antenna (usual

Time value money, I want to buy a car. The Msrp is $31,000. I pay $516 per ...

I want to buy a car. The Msrp is $31,000. I pay $516 per month for five years. The quoted apr is 6.9%. I put down $800. How much did I pay for the car?

Mode ii interlaminar fracture , The Mode II fracture toughness is measured ...

The Mode II fracture toughness is measured using the ENF  Typically, the specimen length is 120 mm, the width B is 20 mm, the thickness is between 3 and 5 mm and the distance be

Hot and cold working, the amount of cold working metal can withstand is dir...

the amount of cold working metal can withstand is directly related to which properties? name two and also discuss the effect that cold working has upon these properties?

Aero Performance Problem, Given data for an F-4 (W=40000 lb, S=530 ft^2, Ta...

Given data for an F-4 (W=40000 lb, S=530 ft^2, Ta@sea level=35800 lb, Mach=1.5, h=20000 ft (std day), Cd0=.0224, k=.1516) find aircraft''s specific excess power in straight-and-lev

Speed control in aircraft engine, Speed control in Aircraft Engine: Bec...

Speed control in Aircraft Engine: Because the APU is designed to run at a constant rpm, some means must be provided to control this speed. Such a control device is known as a

Capital structure of X Ltd. as on 31st Dec 2003, The following is the capit...

The following is the capital structure of X Ltd. as on 31st Dec 2003 Rs in m

Quantitative finance, A fund manager’s high growth portfolio is made up of ...

A fund manager’s high growth portfolio is made up of 80% (w1) in shares and 20% (w2 ) in bonds. Over the course of year 2010, the returns from each asset class are expected to have

Project report, I need help for my project report plz. > Precast concrete p...

I need help for my project report plz. > Precast concrete panels manufactured in factory environments and rapidly cured using steam are being used for the walls of shallow foundati

Write Your Message!

Captcha
Order Assignment

Featured Services

Order Now

Popular Subjects

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +91-977-207-8620

Phone: +91-977-207-8620

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd