Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. in excel (15 percent) suppose you have develop

in excel (15 Percent) Suppose you have developed the following information...

70.2K

Verified Solution

Question

Accounting

in excel
image
(15 Percent) Suppose you have developed the following information for a potential investment: current market value is $1,200,000; anticipated loan to value ratio is 80 with 2 points; and predicated cash flows of ATCF1 =$38,560,ATCF2=$41,780,ATCF3=$37,210,ATCF4= $39,127, and ATER4 =$191,730. Further, assume the investor's minimum required after-tax rate of return on equity is 12%. a. What is the internal rate of return on this potential investment? b. What is the profitability index on this investment

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

?PQR is adjacent to ?RQS. ?PQS is 110 and ?RQS is 34. Find the measure...

Geometry
Q

The 2015 income statement for Egyptian Noise Blasters shows that depreciation expense is $82 million, NOPAT...

Finance
Q

A beam of bright red light of wavelength 654 nm passes through a diffraction grating...

Physics
Q

The bob of a simple pendulum is replaced by a magnet The oscillation are set...

Physics
Q

Intelligence quotients (IQs) on the Stanford-Binet intelligence test are normally distributed with a mean of...

Basic Math
Q

If 1400 square centimeters of material is available to make a box with a square...

Basic Math
Q

Assume v(t) = 5t - 15 on the interval [0, 6]. Find the total distance...

Calculus
Q

One of the most pressing problems confronting the world is global warming. To effectively address...

Accounting
Q

i need help for this Goldman, Inc. manufactures lead crystal glasses. The standard direct...

Accounting
Q

Green Thumb Gardening is a small gardening service that uses activity-based costing to estimate costs...

Accounting
Q

On the first day of the fiscal year, a company issues a $1,000,000,7%, five-year bond...

Accounting
Q

what is the correlation between the performance management system and employee development ?

Finance