1. Call(35) = $9.12, Call(40) = $6.22, Call(45)= $4.08. Using MS Excel, create profit tables andgraphs separately for each long call and then create a single chart showing profit for each longcall on the same graph, clearly label each profit curve.

So you paid premium =For X1 = 35, P1=9.12, For X2 =40 Premium P2 Paid= 6.22 For X 3=45, Premium…

Answered: $6.22, Call long call and th

Business

Finance

$6.22, Call long call and th

Essentials Of Business Analytics

1st Edition

ISBN:9781285187273

Author:Camm, Jeff.

Publisher:Camm, Jeff.

Chapter11: Monte Carlo Simulation

Section: Chapter Questions

Problem 2P

See similar textbooks

Similar questions

Using the table below, create a line chart in which profit or loss is plotted on the Y-axis and sales volume is plotted on the X-axis. This is commonly called a profit/volume chart. Although sales volume can be expressed in either units or dollars, use units for your chart. Complete the Chart Tickler Data Table to include a column for profits. Use this table as a basis for preparing the chart. Cost-Volume-Profit Analysis Data Section Income Statement in a Contribution Margin Fixed Variable Particulars Amounts Production costs Projected unit sales 120,000 Direct materials $2.30 Selling price per unit $16.00 Direct labor 4.70 Less Vairable Cost Factory overhead $225,000 3.00 Direct materials $2.30 Selling expenses Direct labor 4.70 Sales salaries & commissions 97,000 0.75 Factory overhead…
(a) Build a spreadsheet model to calculate the profit/loss for a given demand. What is the demand? (b) Use Goal Seek to calculate the price that results in breakeven. If required, round your answer to two decimal places. c) Use a data table that varies price from 350 to 3400 in increments of 325 to find the price that maximizes profit.
Answer full question.
Click the Chart sheet tab. This chart is based on the problem data and the two income statements. Answer the following questions about the chart: a. What is the title for the X-axis? b. What is the title for the Y-axis? c. What does data range A represent? d. What does data range B represent? e. Why do the two data ranges cross? f. What would be a good title for this chart? When the assignment is complete, close the file without saving it again. Worksheet. The VARCOST2 worksheet is capable of calculating variable and absorption income when unit sales are equal to or less than production. An equally common situation (that this worksheet cannot handle) is when beginning inventory is present and sales volume exceeds production volume. Revise the worksheet Data Section to include: Also, change actual production to 70,000. Revise the Answer Section to accommodate this new data. Assume that Anderjak uses the weighted-average costing method for inventory. Preview the printout to make sure that the worksheet will print neatly on one page, and then print the worksheet. Save the completed file as VARCOSTT. Check figure: Absorption income, 670,000. Chart. Using the VARCOST2 file, fix up the chart used in requirement 5 by adding appropriate titles and legends and formatting the X- and Y-axes. Enter your name somewhere on the chart. Save the file again as VARCOST2. Print the chart.
Wildhorse sells a learning system that helps preschool and elementary students learn basic math facts and concepts. The company income statement from last month is as follows: Total Per Unit Sales revenue $700,000 $50 Variable expenses 315,000 22.50 Contribution margin 385,000 $27.50 Fixed expenses 264,000 Operating income $ 121,000
please help me number it from 1-5
Obtain and study a CVP graph and answer the next multiple choice 22. Select the correct statement concerning the cost-volume-profit graph at right: a. The point identified by "B" is the break-even point. b. Line F is the variable cost line. c. At point B, profits equal total costs. d. Line E is the total cost line. Line F Line E Line D
On the break-even chart you can see the three variants of the break-even points. Name the items marked with numbers in the figure. Choose the correct answers. 7 10 6 Choose... Choose... 7 Choose... 1 Choose... 9. Choose... v Choose... Total cost function (linear) Turning point of profitability Target profit (expected profit) Turning point of economic efficiency Volume Amortisation Total cost - amortisation Total revenue function Turning point of liquidity Total cost + Target profit
An analyst has started preparing a spreadsheet as shown below. Column A contains the headings for various parameters and Column B contains the analyst's range names to be used in Excel. A 1 Price per Unit 2 Cost per Unit 3 Profit per Unit Price_per_Unit Cost per Unit Profit$_per_Unit 4. 5 Fixed Costs 6 Variable Costs Fixed Costs VariableCosts Label each of the following range names as "Correct" if is a valid range name in Excel or "Incorrect" if the range name is not valid for use in Excel. Proposed Range Name Price_per_Unit Cost per Unit Profit$_per_Unit Fixed Costs VariableCosts
Total profit is defined as total revenue, R(x), minus total cost, C(x), and is given by the function P(x) = R(x)- C(x). Given R(x)= 59x-0.4x and Cx)-D3x+14, find each of the following. a) P(x) b) R(80), C(80), and P(80) P(x)= (Type in descending powers of x.)
Fill in the missing amounts in each of the following eight case situations. Treat each case independently. (Hint: One way to find the missing amounts would be to prepare a contribution margin income statement for each case, enter the known data, and then compute the missing items.) a. Assume that only one product is being sold in each of the following four case situations: (Negatlve omounts should be Indicated by a mlnus sign. Enter your contributlon margln answers as per unlt dollor values. Enter your answers rounded to the nearest whole number.) Fixed Еxpenses Net Income (Loss) Variable Contribution Case Units Sold Sales Expenses Margin 14,000 196,000 $9 per unit 46.000 1 106,600 $16 per unit 40% 31,500 59,400 15 10,000 3. 9,900 282,000 $31 per unit 104,000 (8,000) 4 b. Assume that more than one product is being sold in each of the following four case situations: (Negative omounts should be Indicated by a mlnus sign.) Average Contribution Margin (percentage) Variable Fixed Net Income…
:On the cost-volume-profit graph, the intersection between the total cost line and (Y) axis represents The profit area a O The fixed cost amount b O The loss area .c O The contribution margin per unit .d O The variable cost amount eeV@hdows Go to Settings to activate Wil 081 ENG hp 19 11 inprt sc delete home end & num 6 8 9. backspace = lock V { Y U 7 V 8. home H. K enter pause N 1 shift 上 end alt ctrl Pm 近