Explore BrainMass


Please solve using excel.

Chase County Bank agrees to lend Agler Brick Company $300,000 on January 1. Agler Brick Company signs a $300,000, 8%, 9-month note. 8. The entry made by Agler Brick Company on January 1 to record the proceeds and issuance of the note is a. Interest Expense ...................... 18,000 C

Excel Solver Multiple Choice

Terry Corporation had net income of $200,000 and paid dividends to common stockholders of $40,000 in 2003. The weighted average number of shares outstanding in 2003 was 50,000 shares. Terry Corporation's common stock is selling for $60 per share on the New York Stock Exchange. 17. Terry Corporation'

Steps of estimating external financing

Cambridge Prep Shops, a national clothing chain, had sales of $200 million last year. The business has a steady net profit margin of 12 percent and a dividend payout ratio of 40 percent. The balance sheet for the end of last year is shown below. Balance Sheet End of Year (In $ Mi

Need help with part one and Part two

Part one is Perking Up profit at better Brew and Perfect Blend Part two Is Cablevision Slim Down to Beef Up Profits --- Part One Perking Up Profits at Better Brew and Perfect Blend After years of dreaming about owning your own business, you decided that owning a coffee shop would be perfect. Rather than start from

Finance Questions from Annual Report


Two word problems on Present Value

1. Income from a precious metals mining operation has been decreasing uniformly for 5 years. If income in year 1 was $100,000 and it decreased by $10,000 per year through year 5, the present worth of the income at 10% per year is closest to? A. $310,500 B. $352,200 C. $379,100 2. Income from sales of a certain oil additi

Personal Finance Investments...answer questions 1-6

I have received an inheritance for which I need to make wise investment decisions. I have received a $100,000 inheritance and would like to invest. Since I recognize the importance of diversification, invest the amount in a variety of financial instruments. 1. Decide on a good investment mix; in other words, decide what percen

Market Stabilization & Stock Risk: Compute Lynch Brothers' overall gain or loss

Lynch Brothers is the managing underwriter for a 1-million-share issue by Overcharge Healthcare Inc. Lynch Brothers is "handling" 10% of the issue. Its price is $30 per share and the price to the public is $31.50. Lynch also provides the market stabilization function. During the issuance, the market for the stock turned sof

Financial Risks

What are the components of financial risk? How do companies employ diversification to reduce risk?

Japan's Financial Reforms

-The Hashimoto Era and Structural Reforms- Was Hashimotos reform programs feasible, strong enough to keep control over his reform proposal and did it address the problems Japan was facing?

Retirement of Loans

Which is preferable, a loan with a lower present value or a loan with a lower periodic installment? Why? What would be preferable, to retire a loan towards the end of its term or much before it? Explain your answer. If a loan has a pre-payment penalty attached to it, would it still be viable to retire it? Why or why not?

The Vermont Teddy Bear Co.

Develop both an EFAS (External Factors Analysis Summary) Table and an IFAS (Internal Factors Analysis Summary) Table.Tables must be done in Excel showing formulas as well. Attached is the document you are taking the information from. ** See attachments **


NOT FOR 104690 Using the Vermont Teddy Bear Company, develop IFAS & EFAS tables. Include info on the scanning process. Include info on factors considered and why. Preferred Text- Strategic Management and Business Policy, Wheelin & Hunger I have received assistance with identifying the issues but am brainlocked at developi

Break Even Point

The following are the monthly fixed expenses for Peyton Travel: Office rent: $3,000.00 Depreciation of office furniture 200.00 Utilities 110.00 Telephone 520.00 Reservation Service Fees 380.00 Travel Agent Salaries 1,400.00 Variable expenses include the following: Travel Agent Commission 5.0% of sales Advertising 6.

A Department store has the following credit terms

A Department store has the following credit terms the finance charge. If any is based on the previous balance before payments or credits are deducted. The rates are 1.5% per month up to $1,000 and 1.25% per month on amounts in excess of 1,000. These are annual percentage rates of 18% and 15% respectively. Find the new balance fo

Personal finance solve each option

You have received a $10,000 bonus which you would like to invest for your child's education. Calculate the value of the bonus in ten years if invested in each of the following: Option 1: A money market fund that has a current interest rate of 1.75%. Option 2: U.S. Series I bonds (use the current interest rate for I bonds)

Corporate Finance

I am preparing for my FINAL examination(s)...I would like to have these problems solved - so that I can use them for study references in answering like problems. Thank you. --- 1. Global Utilities Company (GUC) follows a policy of paying out 60 percent of its net income as cash dividends to its shareholders each year. Th

Portfolio Analysis

Need some assistance on the following problem. Have an exam and this is a sample problem I cannot figure out. Please include all formulas so I can get a better grasp on this topic. RATE OF RETURN Scenario Probabiltiy Stocks Bonds Recession

2 multiple choice questions

Decision tree analysis shows a project to have several possible outcomes the best of which has an NPV of $12M calculated over a five-year life. This best case path has an overall probability of occurring of 20%. A real option is available at an initial cost of $800,000 which will add a single $6M cash inflow to this best case pa

Determine how many dollars of new funds are needed to finance the growth.

Owen's Electronics has 90 operating plants in seven southwestern states. Sales for last year were $100 million, and the balance sheet at year-end is similar in percentage of sales to that of previous years (and this will continue in the future). All assets (including fixed assets) and current liabilities will vary directly w

Financing decision

How do I answer this without knowing risk or any other information. Your boss is considering borrowing $10,000 from a bank at 8% for a project. She has determined that the rate of return on the project is expected to be 12%. She comments that since the project is earning more than the cost of the

Return on investment

What role does the "frequency of payment" have in determining the return on investment?

What is the breakeven point from the given below information?

What is the breakeven point from the given below information? fixed costs $20,000 variable costs 33% of sales avg selling price is $10,000 a) As % of sales, what is its variable or contribution margin? b) If the average sale is $10,000 what is the contribution margin/vehicle? c