Forecast the income statement and balance sheet for 2008

Assignment Help Financial Management

Reference no: EM131858847

Assignment 1: Forecast the Income Statement and Balance Sheet for 2008. Replicate Balancing Forecasted Assets and Liabilities to Find Funding.

Assume sales and related items increase by 12%

PP&E rises by $9,000,000

Depreciation Expense rises by 450,000

SG&A can rise by any amount you assume.

Assignment 2: "Price a bond by discounting cash flows. Then use the Excel formula to price the bond. Finally, given the bond price, use the Excel formula to get the yield to maturity: Replicate Bond Pricing in Excel### in Sakai using the same Excel formulas and functions. "

The bond: This is for a 8 year bond with semiannual payments. The coupon rate is 7% and the stated yield to maturity is 7.4%.

Assignment 3: Create an Amortization Schedule by replicating Amortization Schedule###, including formulas and Excel functions. Only replicate one sheet where the payment is known.

Loan Length: 25 years

APR 7.2%

Monthly Payment 3,800

Assignment 4: Please replicate the appropriate problem in "Working With Annuities" using the spread sheet as a guide.

You will provide the answer in two ways: by using the sum function and by entering the entire formula in one cell.

You are saving to buy a second honeymoon for your parents. Starting today you will put $440 into a savings account. Each monthly contribution thereafter will be .6% (.006) larger than the one before.

The APR (a stated rate) on the account is 9% and compounding is monthly. How much will you have saved in four years?

Attachment:- Assignment data.rar

Reference no: EM131858847

Questions Cloud

Adequacy of a submitted research proposal : What are some considerations when assessing the adequacy of a submitted research proposal?

Determine which statement is true and why : Which of the following is TRUE? a. Process is in control but we need to monitor the process b. Process is somewhat in control but we need to take more samples.

Substantive and comprehensive for a research study : Why should a literature review be substantive and comprehensive for a research study?

Write down the number of hits that you received : Write down the number of hits that you received for each of these phrases. Find at least three Web sites that provide interesting information on one of topics.

Forecast the income statement and balance sheet for 2008 : Forecast the Income Statement and Balance Sheet for 2008. Replicate Balancing Forecasted Assets and Liabilities to Find Funding.

Godfather fascinate the public : Why do you think that television shows like The Sopranos and movies like The Godfather fascinate the public?

Write a two-page summary of your findings : Write a two-page summary of your findings. Guidelines for your interview and sample questions are available on the companion Web site.

How would you use social influence to make deal work : Consider a situation where you are working as the marketing executive of a company and currently in a meeting with a client for finalizing a sales deal.

Explaining patterns of homicide : What is criminal homicide, and what are key issues involved in explaining patterns of homicide?

User Account

All Pages