I have the answer for this problem but I need to solve it using Excel's PV...

I have the answer for this problem but I need to solve it using Excel's PV function for both products and I cannot seem to figure it out. What would I insert for each portion of the equation into excel?

It has been answered on another question as number 2.

http://www.chegg.com/homework-help/questions-and-answers/lou-barlow-divisional-manager-sage-company-opportunity-manufacture-sell-one-two-new-produc-q12342389?trackid=297667da&strackid=464d9914&ii=8

Solutions

Expert Solution

Calculation of Annual Cash Inflow:

	Product A	Product B
Sales Revenue	2,50,000	3,50,000
Variable Expense	1,20,000	1,70,000
Fixed Out-of-Pocket expense	70,000	50,000
	60,000	1,30,000

Calculated Through PV function	1,96,458	4,25,658
Initial Investment	1,70,000	3,80,000
NPV	26,458	45,658

ekkarill92 answered 11 months ago

Next > < Previous

Related Solutions

I need to solve math problem by using freemat or mathlab program. However, I can't understand...

I need to solve math problem by using freemat or mathlab program. However, I can't understand how to make a code it. This is one example for code ( freemat ) format long f = @(x) (x^2) % define f(x) = x^2 a=0 b=1 N=23 dx = (b-a)/N % dx = delta_x 1. Methods: (a) Left Rectangular Rule also known as Lower sum. (b) Right Rectangular Rule also know as upper sum. (c) Midpoint Rule (d) Trapezoid Rule (e) Simpson...

I have the answer to part A to D. I need the answer to the rest....

I have the answer to part A to D. I need the answer to the rest. Please help. CVP and Sensitivity Analysis (Single Product). Victoria, Inc., has annual fixed costs totaling $240,000 and variable costs of $6 per unit. Each unit of product is sold for $30. Victoria expects to sell 12,000 units this year (this is the base case). Required: Find the break-even point in units. How many units must be sold to earn an annual profit of $100,000?...

I need a fresh answer. Do not copy and paste. Solve only when you have deep...

I need a fresh answer. Do not copy and paste. Solve only when you have deep subject knowledge,. Thank You Please answer the question below. prepare the journal entries for all the following related transaction (all occurring within the current year). Assume all depletion and amoritization for the full year. Also, assume all purchases were made with cash. A. An exploration company purchased land with a valuable ore deposit Estimated ore available in the deposit (in tons) 4,700,000 ...

I need a step by step way to solve this, not just an answer please. THX...

I need a step by step way to solve this, not just an answer please. THX On Jan 1, 2017 Sharpsburg, Inc. issued $400,000, ten-year, 10% bonds for $354,200. The bonds pay interest on June 30 and December 31. The market rate is 12%. What is the carrying value of the bonds at the end of the ten years. According to the book the answer should be $400k, NOT $355,452 like another Clegg member answered.

The Problem Below are a series of problems you need to solve using recursive methods BY...

The Problem Below are a series of problems you need to solve using recursive methods BY using java . You will write a program that will read commands from an input file, with each command referring to one of the recursive problems to be executed. Each command will be followed (on the same line of input) by the respective parameters required for that problem. (15 points for main method) DescArrayCheck (15 points) Write a recursive method that checks whether an...

I have a problem, and I have the answer but I don't know where the solution...

I have a problem, and I have the answer but I don't know where the solution comes from. ( I have to be able to solve these myself so please help me by answering the questions about the problem.) Here is the answer given to me by the professor: What is the density of SF4 vapor at 650 torr and 100 C? 650 torr (1atm/760 Torr)=0.855atm 100C=373K PV=nRT n/v=P/RT= 0.855atm/0.8206l-atm/molek) (373)=0.0279 mole/l M.W. of SF4=108.1 gm/mole Density=mass/volume 0.0279 mole/l(108.1gm/mole) Answer...

Solve for the forces in truss members using the method of sections I just need an...

Solve for the forces in truss members using the method of sections I just need an example

Use EXCEL to format this and solve using solve and explain. Biggest problem is once have...

Use EXCEL to format this and solve using solve and explain. Biggest problem is once have variables (which i have half done) is setting up in Excel. A farmer in the Midwst haas 1,000 acres of land on which she intends to plant corn, wheat, and soybeans. Each acre of corn costs $100 for preparation, requires 7 worker-days of labor, and yields a profit of $30. An acre of wheat costs $120 to prepare, requires 10 worker-days, and yields $40...

Use principles of physics to solve the problem and then verify your answer using the simulation....

Use principles of physics to solve the problem and then verify your answer using the simulation. Assume that the acceleration due to gravity has a magnitude of g = 9.80 m/s2. If the range of the projectile is 5.96 m, the time-of-flight is T = 1.20 s, and air resistance is turned off, determine the following. A. What is the launch angle of the projectile? B. What is the initial speed of the projectile? C. Express the maximum height reached...

Java homework problem: I need the code to be able to have a message if I...

Java homework problem: I need the code to be able to have a message if I type in a letter instead of a number. For example, " Please input only numbers". Then, I should be able to go back and type a number. import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import javax.swing.JButton; import javax.swing.JFrame; import javax.swing.JLabel; import javax.swing.JPanel; import javax.swing.JTextField; public class LoginGui { static JFrame frame = new JFrame("JFrame Example"); public static void main(String s[]) { JPanel panel...

Subjects