short finance question problems

Please read the attachment and include an excel document showing the solutions. Thank you