cost table with graphs using excel

Using the following demand schedule, calculate total revenue, marginal revenue and own-price elasticity of demand. Then show the relation among marginal revenue, price and elasticity of demand. Quantity Marginal Elasticity Price Demanded Revenue Of Demand $60 8 50 16 40 24 30 32 20 40 10 48 ------------------------------------------------------- The first two columns in the following table give a firm's short run production function when the only variable input is labor, and capital (the fixed input) is held constant at 5 units. The price of capital is $2,000 per unit, and the price on labor is $500 per unit. Units... click for more

Managerial economic and strategy (profit and loss)

Managerial economic and strategy (profit and loss)

Annuity's

please provide me an excel sheet with explanation and forumulas so that i can better learn the subject. ========================================== 1. Loan Amortization Schedule - Val Hawkins borrowed $15,000 at a 14 percent annual rate of interest to be repaid over 3 years. The loan is amortized into three equal annual end-of-year payments. a. Calculate the annual end-of-year loan payment b. Prepare a loan amortization schedule showing the interest and principal breakdown of each of the three loan payments. c. Explain why the interest portion of each payment declines with the passage of time. --------------------------- 2. Funding Jill Morgan's Retirement Annuity Su... click for more

WHAT LIFE INSURANCE TO PURCHASE FOR YOUR CHILD

AN ENGINEER RECEIVED BY MAIL THE PROMOTION SHOWN BELOW FROM A LIFE INSURANCE COMPANY.HE HAS A NEW BORN CHILD AND WOULD LIKE TO INSURE THE CHILD,BUT DOES NOT KNOW THE OPTIMUM CHILD AGE AND THE BEST COVERAGE AMOUNT HE SHOULD SIGN UP FOR. HE NOTICES THAT THE MONTHLY PREMIUM STAYS THE SAME FOR EACH AGE GROUP SO THAT IT COULD BE LESS EXPENSIVE IF HE WAITED TILL THE CHILD WAS NEAR 7,15,21,OR 25 YEARS OLD. HE ALSO NOTICES THAT LOWER INSURANCE RATES ARE FOR THE YOUNGER CHILDREN WHO WOULD END UP PAYING SMALLER PREMIUMS BUT FOR LONGER PERIODS. HE NEEDS TO DECIDE ON THE BEST DEAL WHICH NATURALLY DEPENDS ON A VARIETY OF ASSUMPTIONS WITH REGARD TO THE INTEREST RATE, CHILD'S LIFE EXPECTANCY AND INFLATION... click for more

Economics > Cost-Benefit Analysis

Requirement: Please perform a complete and detailed financial analysis and make your recommendation to the management of Johnson and Smith as to which options is more advantages