innovation electronics, inc. has provided you with the year end income statement balance sheet. the controller has asked you to prepare the statement of cash flows for the same year ended december 31. use the information included in the excel simulation and the excel functions described below to complete the task.

Bond x is noncallable and has 20 years to maturity, a 7% annual coupon, and a $1,000 par value. your required return on bond x is 10%; if you buy it, you plan to hold it for 5 years. you (and the market) have expectations that in 5 years, the yield to maturity on a 15-year bond with similar risk will be 9.5%. how much should you be willing to pay for bond x today? (hint: you will need to know how much the bond will be worth at the end of 5 years.) do not round intermediate calculations. round your answer to the nearest cent.

You are thinking of making your mansion more energy efficient by replacing some of the light bulbs with compact fluorescent bulbs, and insulating part or all of your exterior walls. each compact fluorescent light bulb costs $4 and saves you an average of $2 per year in energy costs, and each square foot of wall insulation costs $1 and saves you an average of $0.20 per year in energy costs.† your mansion has 150 light fittings and 3000 sq ft of uninsulated exterior wall. to impress your friends, you would like to spend as much as possible, but save no more than $750 per year in energy costs (you are proud of your large utility bills). how many compact fluorescent light bulbs and how many square feet of insulation should you purchase? how much will you save in energy costs per year? (if an answer does not exist, enter dne.)

1. what is the lowest balance during this period? 2. lily just received her bank statement below. a. what does the bank think her ending balance is? b. how much more does the bank think lily has? c. what transactions are missing? 3. what is the danger of not balancing your bank account? lily’s bank statement deposits: 2/25 $35 2/26 $20 3/1 $256.32 checks: 2/24 ck #301 $25 2/26 #302 $150 debit card: 2/24 american eagle $75.48 2/25 chick fa la $4.67 2/27 mcdonalds $3.56 2/28 chevron $34.76 withdrawal: 2/27 $40 beginning balance $423.34 deposits $311.32 total debits $333.47 ending balance $401.19