Compute the average growth rate of FCF (whole firm) using Excel's LOGEST or LINEST function. Express your answer in decimal notation (i. e., use 0.0123 for 1.23%). You will use this growth rate as the super-normal growth rate (gs) in the following problem

1. FCF = Cash flow from operations less capital expenditures

E. g., for example, for the 12/31/2014 period

FCF_2014 = 3892 - 385 = 3507

2. You must sort FCFs vertically from oldest to newest prior to using the LOGEST or LINEST function.

3.Apply the MGF (Multi-Growth Free Cash Flow) model to TXN (Links to an external site.) using the super-normal growth rate (gs) from the previous problem, long-term growth rate g=4.44%, and WACC=10% to find the Value of operations (Vop). Express your answer in millions (i. e., use 12,300.00 to represent 12.3 billion).

4.Using the data for TXN on the OneDrive http://1drv. ms/1MkWICq and the answers to the previous two problems, compute the intrinsic value per share (based on Average shares diluted) for TXN stock using the MGF (multi-growth FCF) model.

12. nelson corporation, which has only one product, has provided the following data concerning its most recent month of operations: selling price $ 115 units in beginning inventory 380 units produced 5,900 units sold 6,070 units in ending inventory 210 variable costs per unit: direct materials $ 46 direct labor $ 27 variable manufacturing overhead $ 3 variable selling and administrative $ 12 fixed costs: fixed manufacturing overhead $ 112,100 fixed selling and administrative $ 36,420 the company produces the same number of units every month, although the sales in units vary from month to month. the company's variable costs per unit and total fixed costs have been constant from month to month. a. prepare a contribution format income statement for the month using variable costing. unit product cost under variable costing direct materials direct labor variable manufacturing overhead variable costing unit product cost (formula)

1tanner invested $135,000 cash along with office equipment valued at $32,400 in the company in exchange for common stock. 2 the company prepaid $7,200 cash for 12 months’ rent for office space. (hint: debit prepaid rent for $7,200.) 3 the company made credit purchases for $16,200 in office equipment and $3,240 in office supplies. payment is due within 10 days. 6 the company completed services for a client and immediately received $2,000 cash. 9 the company completed a $10,800 project for a client, who must pay within 30 days. 13 the company paid $19,440 cash to settle the account payable created on april 3. 19 the company paid $6,000 cash for the premium on a 12-month insurance policy. (hint: debit prepaid insurance for $6,000.) 22 the company received $8,640 cash as partial payment for the work completed on april 9. 25 the company completed work for another client for $2,640 on credit. 28 the company paid $6,200 cash in dividends. 29 the company purchased $1,080 of additional office supplies on credit. 30 the company paid $700 cash for this month’s utility bill. prepare general journal entries to record these transactions. 2. post the journal entries from part 1 to the ledger accounts.

After graduation, you plan to work for dynamo corporation for 12 years and then start your own business. you expect to save and deposit $7,500 a year for the first 6 years (t = 1 through t = 6) and $15,000 annually for the following 6 years (t = 7 through t = 12). the first deposit will be made a year from today. in addition, your grandfather just gave you a $32,500 graduation gift which you will deposit immediately (t = 0). if the account earns 9% compounded annually, how much will you have when you start your business 12 years from now?