Please show steps and solve in Excel. Please complete by 11:30 pm ET so I have time to use this to study

A.

Solve in Excel.

Jeans Co. setup a $3,000,000 contract with Clothing Inc. Consider the fair market value for each of Jean's Co.'s obligations (see table below). Allocate the total contract price to the correct obligation; use a proportional basis. Based on these calculations, what is the contract price for obligation C?

Obligation	Fair Value
A	$ 1,500,000.00
B	$ 1,000,000.00
C	$ 800,000.00

B. Solve with Excel.

Starbucks gives its customers Star Rewards as an incentive. Starbucks analyzed liabilities related to Star Rewards and found that it gives up about $990,000 as of March 31, 2015. Their unadjusted general ledger at month-end for March reflects a liability balance from Star Rewards of $700,000.

Use the asset-liability approach to record the dollar amount Starbucks should record as an adjustment.