Please help I really am confused on creating these

Calculate the Cost Of Capital

create a Scenario analysis and sensitivity analysis

Pro Forma Balance Sheet
Assets
Current Assets
Cash	$6,281	$24,923	$75,599
Accounts Receivable	$48,486	$83,363	$91,699
Inventory	$7,780	$7,251	$7,976
Other Current Assets	$0	$0	$0
Total Current Assets	$62,547	$115,537	$175,274
Long-term Assets
Long-term Assets	$62,160	$62,160	$62,160
Accumulated Depreciation	$1,200	$2,300	$3,400
Total Long-term Assets	$60,960	$59,860	$58,760
Total Assets	$123,507	$175,397	$234,034
Liabilities and Capital	Year 1	Year 2	Year 3
Current Liabilities
Accounts Payable	$14,064	$14,267	$15,859
Current Borrowing	$0	$0	$0
Other Current Liabilities	$0	$0	$0
Subtotal Current Liabilities	$14,064	$14,267	$15,859
Long-term Liabilities	$101,500	$87,000	$72,500
Total Liabilities	$115,564	$101,267	$88,359
Paid-in Capital	$10,000	$10,000	$10,000
Retained Earnings	($15,150)	($2,057)	$64,130
Earnings	$13,093	$66,187	$71,546
Total Capital	$7,943	$74,130	$145,675
Total Liabilities and Capital	$123,507	$175,397	$234,034
Net Worth	$7,943	$74,130	$145,675