Upload your Excel file here. Ensure that all solutions are…

Upload your Excel file here. Ensure that all solutions are clearly labeled and easy to follow. Name your file using your full name (e.g., Firstname_Lastname_Exam.xlsx). Save your file before uploading it to Canvas. Wait for the upload to complete fully before submitting your exam—do not rush this step!

Tom purchased 40 shares of WolfPack Inc. for $98 per share 5…

Tom purchased 40 shares of WolfPack Inc. for $98 per share 50 days ago. During the holding period, the company paid a dividend of $0.60 per share. Today, Tom sold the shares for $93 each. What is Tom’s holding period return (HPR)?Hint: Enter your answer with two decimal places. For example, enter 12.34 for 12.34%

Tom purchased 40 shares of WolfPack Inc. for $86 per share 5…

Tom purchased 40 shares of WolfPack Inc. for $86 per share 50 days ago. During the holding period, the company paid a dividend of $0.60 per share. Today, Tom sold the shares for $93 each. What is Tom’s holding period return (HPR)?Hint: Enter your answer with two decimal places. For example, enter 12.34 for 12.34%

Record the following adjustment for Sweet Dreams Chocolatier…

Record the following adjustment for Sweet Dreams Chocolatiers Ltd. (“Sweets”):  December 31: $7,000 of service revenue related to catering jobs had been completed in December but had not yet been billed to customers. Date Account Titles Debit Credit Dec 31 #1 7000     #2   7000   When choosing account names, refer to the listing of accounts that was provided at the top of this section. Ensure you spell the account name properly.

Moneypenny Inc. has bonds outstanding with a $1,000 face val…

Moneypenny Inc. has bonds outstanding with a $1,000 face value and 10 years left until maturity. James purchased these bonds 2 years ago for $885. The bonds pay semi-annual interest at an annual coupon rate of 5.4%. Due to an emergency cash need, James now has to sell the bonds and can do so for $750. What is his annualized realized yield on this investment? Hint: Enter your answer as a percentage rounded to two decimal places.

Golden Tiger Trading recently reported annual net income of…

Golden Tiger Trading recently reported annual net income of $265,000 and has 120,000 shares outstanding. The company paid out 70% of its earnings as dividends. They do not plan to change the dividend policy and plan to keep the dividend per share constant in the near future. If investors require a 14% return, what is the fair value of the company’s stock? Enter your answer as a dollar amount rounded to two decimal places.