Complete the steps below using cell references to given data or previous calculations. In some cases, a simple cell reference is all you need. To copy/paste a formula across a row or down a column, an absolute cell reference or a mixed cell reference may be preferred. If a specific Excel function is to be used, the directions will specify the use of that function. Do not type in numerical data into a cell or function. Instead, make a reference to the cell in which the data is found. Make your computations only in the blue cells highlighted below. In all cases, unless otherwise directed, use the earliest appearance of the data in your formulas, usually the Given Data section. The table below summarizes prices (per $100 face value) of various default-free zero-coupon bonds (expressed as a percentage of face value):a. Compute the yield to maturity for each bond. b. Plot the zero-coupon yield curve (for the first five years).c. Is the yield curve upward sloping, downward sloping, or flat?Maturity (years) Price Face Value =$100.001 $95.512 $91.053 $86.384 $81.655 $76.51a. Compute the yield to maturity for each bond. YTM 1-year bond YTM 2-year bond YTM 3-year bond YTM 4-year bond YTM 5-year bond b. Plot the zero-coupon yield curve (for the first five years).c. Is the yield curve upward sloping, downward sloping, or flat?The yield curve is

The last time he flew jet value air, juan's plane developed a fuel leak and had to make an 4) emergency landing. the time before that, his plane was grounded because of an electrical problem. juan is sure his current trip will be fraught with problems and he will once again be delayed. this is an example of the bias a) confirmation b) availability c) selective perception d) randomness

In macroeconomics, to study the aggregate means to study blank

The starr theater, owned by meg vargo, will begin operations in march. the starr will be unique in that it will show only triple features of sequential theme movies. as of march 1, the ledger of starr showed: cash $3,150, land $22,000, buildings (concession stand, projection room, ticket booth, and screen) $10,000, equipment $10,000, accounts payable $7,300, and owner’s capital $37,850. during the month of march, the following events and transactions occurred.mar. 2 rented the three indiana jones movies to be shown for the first 3 weeks of march. the film rental was $3,600; $1,600 was paid in cash and $2,000 will be paid on march 10.3 ordered the lord of the rings movies to be shown the last 10 days of march. it will cost $200 per night.9 received $4,500 cash from admissions.10 paid balance due on indiana jones movies rental and $2,200 on march 1 accounts payable.11 starr theater contracted with adam ladd to operate the concession stand. ladd is to pay 15% of gross concession receipts, payable monthly, for the rental of the concession stand.12 paid advertising expenses $900.20 received $5,100 cash from customers for admissions.20 received the lord of the rings movies and paid the rental fee of $2,000.31 paid salaries of $2,900.31 received statement from adam ladd showing gross receipts from concessions of $6,000 and the balance due to starr theater of $900 ($6,000 × 15%) for march. ladd paid one-half the balance due and will remit the remainder on april 5.31 received $9,200 cash from customers for admissions.1.) enter the beginning balances in the ledger.2.) journalize the march transactions. starr records admission revenue as service revenue, rental of the concession stand as rent revenue, and film rental expense as rent expense. (credit account titles are automatically indented when the amount is entered. do not indent manually. record journal entries in the order presented in the problem. if no entry is required, select "no entry" for the account titles and enter 0 for the amounts.)3.) post the march journal entries to the ledger. (post entries in the order of journal entries presented in the previous question.)