Purchase Solution

Computing cash flow analysis with NPV

Not what you're looking for?

Ask Custom Question

In the current year ( year 0), Amisha became a shareholder in Sultan Inc., a calendar year S corporation, by contributing $15,000 cash in exchange for stock. Shortly before the end of the year, Sultan's CFO notified Amisha that her pro rata share of ordinary loss for the year would be 55,000. Amisha immediately loaned $40,000 to Sultan in exchange for a two-year, interest-bearing corporate note. Consequently, she had enough stock and debt basis to allow her to deduct the $55,000 loss on her current year return.

Compute the NPV of Amish's cash flow associated with her loan in the following three cases. In each case, assume she has a 35 percent marginal tax rate on ordinary income, a 15 percent on capital gains, and uses a 6 percent discount rate.

a. For the next two years (year 1 and 2), Amisha share of Sultans ordinary income totaled $49,000, and sultan did not distribute any cash to its shareholders. However, it did repay the $40,000 loan plus $3,800 interest in year 2.

b. For the next two years (year 1 and year 2), Amisha share of Sultan ordinary income totaled $19,100, and Sultan did not distribute any cash of its shareholders. However, it did repay the $40,000 loan plus 3,800 interest year 2.

c. For the next two years (year 1 and year 2), Amisha share of Sultans ordinary loss totaled $11,400. In year 2, the corporation declared bankruptcy and defaulted on all its debts, including the loan from Amisha.

Purchase this Solution

Solution Summary

This solution provides calculations for cash flow analysis in Excel.

Purchase this Solution


Free BrainMass Quizzes
Employee Orientation

Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.

Introduction to Finance

This quiz test introductory finance topics.

Team Development Strategies

This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.

Accounting: Statement of Cash flows

This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.

Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.