subject
Business, 02.01.2020 21:31 jaallen3679

You have a project that will involve the purchase of real estate and renovation of the real estate.
your our analysis indicates the project should have an irr of 10 percent. financing will consist of a mortgage (debt) of $90,000 dollars which represents 80 percent of the financing. the pretax cost of debt is estimated to be 8.5 percent. the remaining proportion of the financing will come from selling shares of your stock portfolio. historically, your return has been 11 percent. your marginal tax rate is 21 percent.
how would excel be used to figure this out?
should you pursue the project?

ansver
Answers: 1

Another question on Business

question
Business, 22.06.2019 10:00
University car wash built a deluxe car wash across the street from campus. the new machines cost $219,000 including installation. the company estimates that the equipment will have a residual value of $19,500. university car wash also estimates it will use the machine for six years or about 12,500 total hours. actual use per year was as follows: year hours used 1 3,100 2 1,100 3 1,200 4 2,800 5 2,600 6 1,200 prepare a depreciation schedule for six years using the following methods: 1. straight-line. 2. double-declining-balance. 3. activity-based.
Answers: 1
question
Business, 22.06.2019 11:00
Factors like the unemployment rate,the stock market,global trade,economic policy,and the economic situation of other countries have no influence on the financial status of individuals. true or false
Answers: 1
question
Business, 22.06.2019 11:10
Which of the following is an example of a production quota? a. the government sets an upper limit on the quantity that each dairy farmer can produce. b. the government sets a price floor in the market for dairy products. c. the government sets a lower limit on the quantity that each dairy farmer can produce. d. the government guarantees to buy a specified quantity of dairy products from farmers.
Answers: 2
question
Business, 22.06.2019 14:50
Pear co.’s income statement for the year ended december 31, as prepared by pear’s controller, reported income before taxes of $125,000. the auditor questioned the following amounts that had been included in income before taxes: equity in earnings of cinn co. $ 40,000 dividends received from cinn 8,000 adjustments to profits of prior years for arithmetical errors in depreciation (35,000) pear owns 40% of cinn’s common stock, and no acquisition differentials are relevant. pear’s december 31 income statement should report income before taxes of
Answers: 3
You know the right answer?
You have a project that will involve the purchase of real estate and renovation of the real estate.<...
Questions
question
Mathematics, 10.11.2019 23:31