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

Lab 3 Problem Set Name Temp X 57 77 Ice Cream Sales 215 401

Statistics
Q

An employee has come to you with a request to take on a part-time job. The...

General Management
Q

Sila In 1 2 State type of dilation and scale factor answer in simplest fraction...

Geometry
Q

3 The probability are 0 4 0 2 0 3 and 0 1 respectively that...

Basic Math
Q

Customers were asked to name their favorite soft drink The results are as follows Construct...

Basic Math
Q

An experimental drug was given to a sample of 95 hospital patients with an unknown...

Basic Math
Q

Measures Solve the system of linear equations by graphing X 6 y 5

Calculus
Q

C 4 2 25 D 4 25 5 0 6m 2 20 6 2 2...

Algebra
Q

efer to the following selected financial information from Gomez Electronics. Compute the...

Accounting
Q

Can someone help me with this question please. I will give a fast upvote. Please...

Accounting
Q

Suppose you purchase a 13-year U.S. savings bond with an APR of 3.0%. The face...

Accounting
Q

what is a continouse budget

Accounting