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