show all work on excel including formulas please

used for seatonal finanking but instead are part of the consariy's permanent cafntal structure The fong ferm debt consists of 30 , cao bonds. debt rai is 1 whand this is the preterat yeld to maturity on the bonds. The common stock selfs at a orice of feo per bhare. caiculace the perceritage yaluea to two cecanal places. Short-term debt Lorg term dest Common equity Total capiral