In this problem, you will create an amortization schedule for a car loan for 5 years with a fixed APR given.
Steps to Perform:
2 In cell B10, enter the balance at the beginning of month 1. Format cell B10 as Currency with 2 decimal places.
3 In cell B11, enter the balance at the beginning o...

Acme stock is trading at $120 per share, and the company will not pay any dividends over the next year. Consider an Acme European call option and a European put option, both having an exercise price of $124 and both maturing in exactly one year. The simple (annualized) interest rate for borrowing an...

Shares of Novotel will sell for either $150 or $80 three months later, with probabilities 0.60 and 0.40, respectively. A European call with an exercise price of $100 sells for $25 today, and an identical put sells for $8. Both options mature in three months. What is a price of a three-month zero-cou...

What is the difference between Restricted Stock, Share Repurchases, Stock Option?
Will each of these transactions have a direct effect on the company financial situation?

How to analyze a company financial performance, using the following tools:
Profitability Analysis
Profit Margin Analysis
Asset Turnover
Fixed Asset Turnover
Rate of Return on Common Shareholders' Equity
Earning Per Common Share

1. Of the 45 U.S. presidents, 4 have been assassinated in office. What percent have been assassinated? Round the percentage to two decimal places.
2. The total expenses for Claire's recent business trip were $1040. She put $884 on her charge card and paid the balance in cash. What percentage...

During the summer you had to spend some time with your uncle, who is a wheat farmer. Your uncle, knowing you are studying for an MBA at Harvard, asked your help. He is afraid that the price of wheat will fall, which will have a severe impact on his profits. Thus he asks you to compute the 1yr forwar...

As an Ivy Tech student, you are making an investment in your education. This project will look at how that investment will pay off if you graduate and get a job in your desired field.
The median annual income for a high school graduate is $25,000. This is the value that you will be comparing you...

1. Create an Excel spreadsheet that can do the calculations for the credit card below. Using formulas and the drag function of Excel (see the notes), find the values for 1 year of charges.
With a beginning balance of $1950 and no additional charges, you will just pay the minimum payment each mon...

Zeus Solutions (ZS), an online advertising company, expects next year's after tax earnings to be $20 per share. Its business is still expanding. It plows back 80% of its earnings. The ROE on its new investments is 15%. Its cost of capital is 12.5%.
(a) What is the share price of Zeus Solutions? W...

1) You are an analyst in a major investment bank and have been assigned the task of determining the share price of Foodmart, a national supermarket chain. The stock beta is 1.286, Rf=3%, Rm=10%. The cost of debt is 6.82%. The tax rate is 34% and the firm is 40% debt financed.
Calculate the WACC for...

John Gunho wants to purchase a condominium, he will be taking out a mortgage for the condo. The purchase price for the condo is $42,000 at an annual rate of 7.2%. He reviewed his options for the term, and he knows the effects of compounding interest, so he plans to take a one year term mortgage.
(...

Orange County Health, a health service company, is expected to generate $1 in earnings per share next year and in the years to follow, from its existing assets. It plans to announce a new program to expand its business. This new program will increase its plow back ratio from zero to 50% next year. T...

1) What is the holding period return (percentage return on this investment) to an investor who bought 100 shares of Charter Oil nine months ago for $36 a share, received two $50 dividend checks, and sold the stock today at $38 a share?
2) What is the market price of a share of stock for a firm th...

Hi I'm having some issues with the numbers below. I'm using Excel to complete all problems 1-15 however I only need help on the ones below.
1. You buy a stock for $20. After a year the price rises to $25 but falls back to $20 at the end of the second year. What was the average percentage return ...

Please take a look at Bed Bath and Beyond's stock prices here and help me answer the following questions: https://finance.yahoo.com/quote/BBBY?p=BBBY
Please review the company's dividends over the past three years. Then, answer the following questions in Word (except for the Excel portion specif...

A steel mill produces two types of steel alloy: boral and chromal. Production of each alloy requires three processes: Box anneal, Cold Roll, and Strand anneal. Production capacities are:
Box anneal: 4,000 hours/month
Cold Roll: 500 hours/month
Strand anneal: 1,000 hours/month
Production rates in...

An advertisement in the newspaper offers a new car for sale or lease. The purchase price of the car is $43,240, or the car can be leased for 24 months for a monthly payment of $458, with a $7,500 down-payment. Under the lease option, there is a charge of 24 cents/mile for mileage above 30,000 miles ...

Develop two simulation models of tossing two six-sided dice (numbered 1 through 6 on the six faces).
Model 1: Simulate rolling a single die twice and add the total.
Model 2: Simulate a combined roll of two dice, giving a number from 2 through 12 with appropriate probabilities.

A. What situations might have created the budget deficit for the Constantine family?
B. What amounts would you suggest for the various categories for the family budget?
C. Describe additional actions for the Constantine family related to their budget or other money management activities.
Adjust...

Career Decision:
Life Situation
Single - Age 21
No dependents
College student
Financial Data Monthly Income $1,750
Living Expenses $1,210
Personal property $7,300
Savings $2,000
Student loan $3,000
Credit card debt $2,400
Shelby Johnson's current employment position, a grooming speci...

Situation 1:
Fran and Ed Blake, ages 43 and 47, have a daughter who is completing her first year of college and a son three years younger. Currently, they have $42,000 in savings and investment funds set aside for their children's education. With increasing education costs, they are concerned wheth...

Explain the difference between a capital expenditure and a revenue expenditure. Also, give an example of each and explain the difference in the method of accounting for each expenditure. Explain if there are times that it would be in management's best interest to "shift" an expenditure from a capita...

What are the ethical implications of federal minimum wage? Who does it help, and who does it harm? Does raising the current level of the minimum wage increase unemployment, drive business away, or harm the very poor? Will a higher minimum wage raise the standard of living and buying power of the wag...

Do you agree that when one enters into a disadvantageous bargaining position because of one's own voluntary acts (such as ignoring a warning) that an otherwise exploiting act becomes morally permissible because the person assumed the risk, or is the act always impermissible because the person is esp...

Describe how the bank reconciliation can be used as an internal control tool for cash. Also, should the same person that receives cash payments prepare the bank reconciliation? Give at least one reason to support your answer.

Creating a memo to management including the following:
Describe the use of internal rate of return (IRR), net present value (NPV), and the payback method in evaluating project cash flows.
Describe the advantages and disadvantages of each method.
Calculate the following time value of money ...