On January 1, Intergen, Inc., invests $200,000 for a40 percentinterest in Ryan, a new jointventure with two other partners, each investing $150,000 for 30 percent interests. Intergen plansto sell all of its production to Ryan, which will resell the inventory to retail outlets. The equitypartners agree that Ryan will buy inventory only from Intergen. Also, Intergen plans to use theequity methodfor financial reporting.During the year, Intergen expects to incur costs of $850,000 to produce goods with a final retailmarket value of $1,200,000. Ryan projects that, during this year, it will resell three-fourths ofthese goods for $900,000. It should sell the remainder in the following year.The equity partners plan a meeting to set the price Intergen will charge Ryan for its production.One partner suggests a transfer price of $1,025,000but is unsure whether it will result in anequitable return across the equity holders. Importantly, Intergen agrees that its total rate of return(including its own operations and its investment in Ryan) should be equal to that of the otherinvestors' return on their investments in Ryan. All agree that Intergen's value including itsinvestment in Ryan is $1,000,000. Required 1. Create an Excel spreadsheet analysis showing the following: Projected income statements for Intergen and Ryan. Formulate the statements to do the following Link Ryan's cost of goods sold to Intergen's sales (use a starting value of$1,025,000 for Intergen's sales). Link Intergen's equity in Ryan's earnings to Ryan's net income (adjusted forIntergen's gross profit rate × Ryan's ending inventory × 40 percent ownership percentage). Be able to change Intergen's sales and see the effects throughout the incomestatements of Ryan and Intergen. Note that the cost of goods sold for Intergen is fixed. The rate of return for the two 30 percent equity partners on their investment in Ryan. The total rate of return for Intergen based on its $1,000,000 value. 2. What transfer price will provide an equal rate of return for each of the investors in the first year of operation? (Hint:Under Excel's Tools menu, use the Goal Seek or Solver capability toproduce a zero difference in rates of return across the equity partners by changing the cell thatcontains Intergen's sales.)

On January 1, Intergen, Inc., invests $200,000 for a40 percentinterest in Ryan, a new jointventure with two other partners, each investing $150,000 for 30 percent interests. Intergen plansto sell all of its production to Ryan, which will resell the inventory to retail outlets. The equitypartners agree that Ryan will buy inventory only from Intergen. Also, Intergen plans to use theequity methodfor financial reporting.During the year, Intergen expects to incur costs of $850,000 to produce goods with a final retailmarket value of $1,200,000. Ryan projects that, during this year, it will resell three-fourths ofthese goods for $900,000. It should sell the remainder in the following year.The equity partners plan a meeting to set the price Intergen will charge Ryan for its production.One partner suggests a transfer price of $1,025,000but is unsure whether it will result in anequitable return across the equity holders. Importantly, Intergen agrees that its total rate of return(including its own operations and its investment in Ryan) should be equal to that of the otherinvestors' return on their investments in Ryan. All agree that Intergen's value including itsinvestment in Ryan is $1,000,000. Required 1. Create an Excel spreadsheet analysis showing the following: Projected income statements for Intergen and Ryan. Formulate the statements to do the following Link Ryan's cost of goods sold to Intergen's sales (use a starting value of$1,025,000 for Intergen's sales). Link Intergen's equity in Ryan's earnings to Ryan's net income (adjusted forIntergen's gross profit rate × Ryan's ending inventory × 40 percent ownership percentage). Be able to change Intergen's sales and see the effects throughout the incomestatements of Ryan and Intergen. Note that the cost of goods sold for Intergen is fixed. The rate of return for the two 30 percent equity partners on their investment in Ryan. The total rate of return for Intergen based on its $1,000,000 value. 2. What transfer price will provide an equal rate of return for each of the investors in the first year of operation? (Hint:Under Excel's Tools menu, use the Goal Seek or Solver capability toproduce a zero difference in rates of return across the equity partners by changing the cell thatcontains Intergen's sales.)

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Related questions

Question

Required 1. Create an Excel spreadsheet analysis showing the following:

Projected income statements for Intergen and Ryan. Formulate the statements to do the following
- Link Ryan's cost of goods sold to Intergen's sales (use a starting value of$1,025,000 for Intergen's sales).
- Link Intergen's equity in Ryan's earnings to Ryan's net income (adjusted forIntergen's gross profit rate × Ryan's ending inventory × 40 percent ownership percentage).
- Be able to change Intergen's sales and see the effects throughout the incomestatements of Ryan and Intergen. Note that the cost of goods sold for Intergen is fixed.
- The rate of return for the two 30 percent equity partners on their investment in Ryan.
- The total rate of return for Intergen based on its $1,000,000 value.

2. What transfer price will provide an equal rate of return for each of the investors in the first year of operation? (Hint:Under Excel's Tools menu, use the Goal Seek or Solver capability toproduce a zero difference in rates of return across the equity partners by changing the cell thatcontains Intergen's sales.)

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 4 steps with 3 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.