A 1 2 On January 1, Ruiz Company issued bonds as follows: 3 4 Face Amount: 5 6 16 a) Market Interest Rate: 17 B Semiannual Interest Payment: Bond Selling Price: Number of Years: Stated Interest Rate: 7 Interest payments per year 8 Note: The bonds pay interest semiannually. 9 10 Required: 11 1) Given the different market interest rates below, calculate the following items. 12 Calculate the bond selling price using the Excel PV function. Enter all function arguments as cell references. 13 $500,000 30 7% 2 14 (Use cells A4 to B7 from the given information to complete this question.) 15 Semiannual Interest Payment: Bond Selling Price: 26 The bond in (a) sold at a: 27 The bond in (b) sold at a: 28 C 9% 18 19 20 b) Market Interest Rate: 21 22 23 24 2. Use the answer either "Premium" or "Discount" to the following items. 25 D 5.50% F G H

During the research​ process, if you are unsure whether or not​ you've found all the relevant​ literature, what should you​ do?   A. Google it to see if there is anything else​ you've missed.   B. Call your manager to verify that​ you've found it all.   C. Use the search engine included in the Codification.   D. Complain that​ it's too much work and call it a day.

is there a way to do this question with formulas and a calculator instead of excel? if so please upload the solution this way

Further info is in the attached images For the Excel part of the question give the solutions in the form of the Excel equations. Please and thank you! :) Download the Applying Excel form and enter formulas in all cells that contain question marks. For example, in cell B34 enter the formula "= B9". After entering formulas in all of the cells that contained question marks, verify that the dollar amounts match the example in the text. Check your worksheet by changing the beginning work in process inventory to 100 units, the units started into production during the period to 2,500 units, and the units in ending work in process inventory to 200 units, keeping all of the other data the same as in the original example. If your worksheet is operating properly, the cost per equivalent unit for materials should now be $152.50 and the cost per equivalent unit for conversion should be $145.50. Thank you!

Please help on parts 4 and 5. Please also show work on how to do.

Hello i have attached two pictures. They are both used together to answer the question. The first picture is the information to use too answer the question. The second attachment is the for the answer. I hope it is understandable and whoever answer this can please explain how they got the answers. I need the help. I have marked a yellow x on what i have done already. I DO NOT NEED HELP WITH WHAT IS CROSSED IN YELLOW (PARTS 1-3) I NEED PARTS 4-6. THIS IS IS IS THE ANSWER TO PARTS 1-3  Analysis and Calculation: 1) Gold Medal Athletic Co.,  Sales Budget: For the month ended March: Product Sales Volume Sale Price per unit Sales, $ Batting helmet  1,200 units $40  $ 48,000 Football helmet  6,500 units $160  $1,040,000 Total revenue from sales      $ 1,088,000   2) Production Budget:   Batting Football   Helmet Helmet Expected units to be sold  1,200  6,500 Add: desired Ending inventory  50  220 Total  1,250  6,720 Less: Beginning estimated inventory  40  240 Total…

Q1: Write an e-mail to technical support team of your college to retrieve your login credentials. In order to make your e- mail effective mention all the important details and reasons to prioritize your response

I uploaded two pictures of the entire excel spreadsheet that I am trying to figure out. All the spots that say "FORMULA" needs solved.

can you do it again, please, no tables, only formulas, please