ADM 1370 Study Guide - Midterm Guide: Purchase Order, Business Intelligence, Autosave

490 views3 pages

rubyhare624

7 Feb 2016

School

Department

Course

Professor

For unlimited access to Study Guides, a Grade+ subscription is required.

Document Summary

What would be the result of the function expression shown in cell e6 in figure above: 40250, 40000, 21, 21. 75 the figure above, 0, 161000, 84000, 126000. A formulation using solver in excel requires three main elements: Target cell, constraints cells, and ___: row input cells, changing cells, column input cells, rule cells. While specific cells can be named in excel, ranges of cells cannot be. Which of these information presentations is more dynamic & Consider the screenshot below showing a worksheet with details of a purchase order with three products, the quantity, and the price per unit. Which of the following formulas will correctly calculate the value shown in cell. B6: sumproduct (b2:c4, sumproduct (b1:b4, c1:c4, sumproduct (b2:b4, c2: c4, sumproduct(a2:c4, , d, , d3. Which of the following is an example of an absolute cell reference. Which of the following excel functions is an example of a financial. 16) function: max function, median function, fv function, rpt function.

Related Questions

Multiple Choice

1. You have a large dataset that will print on several pages. You want to ensure that related records print on the same page with column and row labels visible and that confidential information is not printed. You should apply all of the following page setup options except which one to accomplish this task?

(a) Set a print area.

(b) Print titles.

(d) Change the print page order.

2. You are working with a large worksheet. Your row headings are in column A. Which command(s) should be used to see the row headings and the distant information in columns X, Y, and 2?

(a) Freeze Panes command

(b) Hide Rows command

(d) Split Rows command

3. Which statement is not a recommended guideline for designing and creating an Excel table?

(a) Avoid naming two fields with the same name.

(b) Ensure that no blank columns separate data columns within the table.

(c)-Leave one blank row between records in the table.

(d) Include field names on the first row of the table.

4. Which of the following characters are wildcards in Excel? (Check all that apply.)

(a) *

(b) #

(e) ?

(d) $

5. What should you do to ensure that records in a table are unique?

(a) Do nothing; a logical reason probably exist to keep identical records.

(b) Use the remove duplicates command.

(d) Find the duplicate records and change some of the data to be different

6. Which Conditional Formatting rule is best suited to apply formatting to the top five values in a range of values?

(a) Above Average

(b) Greater Than

(c). Top 10 Items

(d) Between

7. Which date filter option enables you to restrict the view to only dates that occur in March of 2018?

(a) Equals

(b) Before

(d) Between

8. Which of the following is an unqualified structured reference?

(a) =[Purchase_Price]-[Down Payment]

(b) =Sales[Purchase_Price]-Sales[Down_Payment]

(d) =[Sales]Purchase_Price [Sales]Down_Payment

9. Which of the following is not an aggregate function that can be applied in a total row?

(a) MAX

(b) AVERAGE

(d) VLOOKUP

10. If you would like to set a conditional formatting rule based on the function=AND(G6"Finance". H7<7000), which formatting rule type is needed?

(a) Format all cells based on their values

(b) Format only cells that contain

(d) Format only values that are above or below average

burgundycoyote150

Bond valuation

The process of bond valuation is based on the fundamental concept that the current price of a security can be determined by calculating the present value of the cash flows that the security will generate in the future.

There is a consistent and predictable relationship between a bondâs coupon rate, its par value, a bondholderâs required return, and the bondâs resulting intrinsic value. Trading at a discount, trading at a premium, and trading at par refer to particular relationships between a bondâs intrinsic value and its par value. These result from the relationship between a bondâs coupon rate and a bondholderâs required rate of return.

Remember, a bondâs coupon rate partially determines the interest-based return that a bond (might/will)...........pay, and a bondholderâs required return reflects the return that a bondholder(would like/is obligated).............to receive from a given investment.

The mathematics of bond valuation imply a predictable relationship between the bondâs coupon rate, the bondholderâs required return, the bondâs par value, and its intrinsic value. These relationships can be summarized as follows:

â¢	When the bondâs coupon rate is equal to the bondholderâs required return, the bondâs intrinsic value will equal its par value, and the bond will trade at par.
â¢	When the bondâs coupon rate is greater to the bondholderâs required return, the bondâs intrinsic value will (be less than/exceed/equal)................ its par value, and the bond will trade at a premium.
â¢	When the bondâs coupon rate is less than the bondholderâs required return, the bondâs intrinsic value will be less than its par value, and the bond will trade (at a premium/at par/at a discount).............................

For example, assume Liam wants to earn a return of 5.00% and is offered the opportunity to purchase a $1,000 par value bond that pays a 8.75% coupon rate (distributed semiannually) with three years remaining to maturity. The following formula can be used to compute the bondâs intrinsic value(Link to the formula : http://q4pws.aplia.com/q4pws/rest/1.0/image/image9594/img.png?data=q4%3AREMOTE_URL%3Ahttp%3A%2F%2Faplia-prod-webjboss-372923237.us-east-1.elb.amazonaws.com%2Fproblemsetassets%2Fq4_export%2Ffinance%2Fq4problems%2F3061500.08.xml%2CV5%2C291%2C1%2CSTUDENT%2CSTUDENT%2C0%2Cq4pws-aplia-7.6.4-G2f8d8babd91356776c6b2ec65d5e2a2153b4d346-B36-2015.12.16-03%3A57-PM-PST&oauth_signature=jG%2Fu63kSgI9xRhXign5JItWfpAQ%3D&oauth_version=1.0&oauth_nonce=3573483745&oauth_signature_method=HMAC-SHA1&oauth_consumer_key=q4-callback&oauth_timestamp=1454953012

Complete the following table by identifying the appropriate corresponding variables used in the equation.

unknown --------------------- variable name ---------------------variable value

A --------------------- (Bondholders required return/Bonds annual coupon payment/Bonds semiannual coupon payment)---------------------($21.88/$65.63/$87.50/$43.75)

B--------------------- (Bonds par value/bonds annual coupon payment/semiannual coupon payment) ---------------------$1000

C--------------------- semiannual required return -------------------- ($5.75/$3.81/$4.38/$2.5)

Based on this equation and the data, it is (reasonable/unreasonable)...................to expect that Liamâs potential bond investment is currently exhibiting an intrinsic value greater than $1,000.

Now, consider the situation in which Liam wants to earn a return of 5.75%, but the bond being considered for purchase offers a coupon rate of 8.75%. Again, assume that the bond pays semiannual interest payments and has three years to maturity. If you round the bond's intrinsic value to the nearest whole dollar, then its intrinsic value of ($757/$866/$1407/$1082).................is (equal to/greater than/less than).............................its par value, so that the bond is trading at (par/a discount/a premium)..............................

Given your computation and conclusions, which of the following statements is true?

(a)When the coupon rate is greater than Liamâs required return, the bond should trade at a discount.

(b)A bond should trade at a par value when the coupon rate is greater than Liam's required return

(c) When the coupon rate is greater than Liamâs required return, the bond's intrinsic value will be less than it's par value

(d) When the coupon rate is greater than Liamâs required return, the bond should trade at a premium

ADM 1370 Study Guide - Midterm Guide: Purchase Order, Business Intelligence, Autosave

Document Summary

Get access

Related Documents

ADM 1370 Study Guide - Income Statement

ADM 1370 Study Guide - Final Guide: Lookup Table, Pearson Product-Moment Correlation Coefficient, Emv

ADM 1370 Lecture Notes - Lecture 1: Lookup Table, Killer Application, Emv

Related Questions