Marina collects and records data in an Excel spreadsheet. She uses the data to produce a line graph.
Marina wants to change the graph so the minimum distance on the y-axis is 0. What should be done to make this change?
A. Adjust the Minimum option to Fixed and change to 0.
B. Adjust the chart style to a 3-D chart so all the data will be displayed.
C. Adjust the selection pane so that the full range of data is selected.
D. Adjust the intervals between tick marks to -10 in the Axis Options box.
Answers
Answer:
A. Adjust the Minimum option to Fixed and change to 0.
Explanation:
Took the course
Related Questions
Ending raw materials would appear in which of the following budgets?
(A) Debit Labor Budget
(B) Direct Materials Budget
(C) Budgeted Income Statement
(D) Sales Budget
Answers
Answer:
B
Explanation:
Raw materials will fall under a material budget as it is only for purchasing the raw materials
For the past year, Kayla, Inc., has sales of $46,382, interest expense of $3,854, cost of goods sold of $16,659, selling and administrative expense of $11,766, and depreciation of $6,415. If the tax rate is 35 percent, what is the operating cash flow
Answers
Answer:
$15,266
Explanation:
Sales $46,382
Less: Cost of goods sold $16,659
Gross profit $29,723
Less: Selling & administrative expense $11,766
Less: Depreciation $6,415
Earnings before interest and tax (EBIT) $11,542
Less: Interest expenses $3,854
Earnings before tax (EBT) $7,688
Less: Tax expenses (7688*35%) $2,691
Earnings after tax $4,997
Operating cash flow = EBIT + Depreciation expenses - Tax expenses
Operating cash flow = $11,542 + $6,415 - $2,691
Operating cash flow = $15,266
Liu, the owner of San Diego Mortgage Solutions, a sole proprietorship, wants to obtain additional business capital to expand operations. The additional business capital is most likely limited to Group of answer choices conducting a private offering. issuing stock. bringing in partners. borrowing funds.
Answers
Answer:
borrowing funds.
Explanation:
Since the owner could not add extra partners as it would be transform into the partnership firm in the case when there is an increase in the number of owners.
In the sole propertiorship, there is only one stockholder and he cant able to issue the stock or the initial public offering
Therefore it would be limited to the borrowing funds
On January 1, 2016, ABC Corporation purchased Equipment C for $72,000. Equipment C is expected to have a useful life of 8 years, and a salvage value of $2,400. Assume that ABC uses the straight-line method of depreciation for Equipment C. A Prepare the journal entry to record depreciation on the equipment for 2016. (5)
Answers
Answer:
Debit : Depreciation $8,700
Credit : Accumulated Depreciation $8,700
Explanation:
the journal entry to record depreciation on the equipment for 2016.
At Sheridan Electronics, it costs $30 per unit ($16 variable and $14 fixed) to make an MP3 player that normally sells for $49. A foreign wholesaler offers to buy 4,570 units at $25 each. Sheridan Electronics will incur special shipping costs of $1 per unit. Assuming that Sheridan Electronics has excess operating capacity, indicate the net income (loss) Sheridan Electronics would realize by accepting the special order.
The special order should be:________
Answers
Answer:
Reject Accept Net Income
order order increase / (decrease)
Revenues $0 $114,250 $114,250
(4570*25)
Cost - variable manufacturing $0 $73,120 ($73,120)
(4570*16)
Shipping $0 $4,570 ($4,570)
(4570*1)
Net Income $0 $36,560 $36,560
So, the special order should be accepted.
Tabitha sells real estate on March 2 of the current year for $334,000. The buyer, Ramona, pays the real estate taxes of $16,700 for the calendar year, which is the real estate property tax year. Round any division to four decimal places and use in subsequent calculations. Round your final answers to the nearest dollar. Assume a 365-day year.
Answers
Answer:
Requirement "Determine the real estate taxes apportioned to and deductible by the seller, Tabitha, and the amount of taxes deductible by Ramona. Tabitha"
Tabitha will pay the Real estate tax until March 1 and this would be deductible from Tabitha. No of days = 60 days (January 1 to March 1)
Amount of tax deductible from Tabitha = $16,700* (60/365)
= $16,700 * 0.1644
= $2,745.48
= $2,745
Amount of tax deductible from Ramona = $16,700 * (305/365)
= $16,700 * 0.8356
= $13954.52
= $13,955
The Core Company had the following assets and liabilities as of December 31: Assets Cash $58,000 Accounts receivable 25,000 Inventory 20,000 Equipment 50,000 Liabilities Current portion of long-term debt $20,000 Accounts payable 12,000 Long-term debt 25,000 Calculate the current ratio, working capital, and quick ratio. If required, round your answers to one decimal place. Current Ratio fill in the blank 1 Working Capital $fill in the blank 2 Quick Ratio fill in the blank 3
Answers
Answer:
Current Ratio 3.2
Working Capital $71,000
Quick Ratio 2.6
Explanation:
Calculation to determine Current Ratio, Working Capital and Quick Ratio Correct Answer:
Current Ratio= ($58,000 + $25,000 + $20,000) / ($20,000 + $12,000)
Current Ratio= $103,000/32,000
Current Ratio = 3.2
Working Capital= $103,000 - $32,000
Working Capital= $71,000
Quick Ratio=($58,000 + $25,000) / ($20,000 + $12,000)
Quick Ratio=$83,000/$32,000
Quick Ratio= 2.6
Therefore:
Current Ratio 3.2
Working Capital $71,000
Quick Ratio 2.6
Dell has a standard usage of 1 pound direct materials. Direct materials have a standard price of $26 per pound. In April, Dell produced 4,790 units and paid $142,000 for 5,030 pounds direct materials. Calculate the direct materials quantity variance.
Answers
Answer:
the direct material quantity variance is $6,240 unfavorable
Explanation:
The computation of the direct material quantity variance is shown below:
The direct material quantity variance is
= (Actual quantity - standard quantity) × standard price
= (5,030 pounds - 4,790 pounds) × $26
= $6,240 unfavorable
Hence, the direct material quantity variance is $6,240 unfavorable
The same would be considered and relevant
At the beginning of 2019, Sunshine Corporation issued 18,000 shares of $100 par, 7%, cumulative, preferred stock for $110 per share. No dividends have been paid to preferred or common shareholders. What amount of dividends will a preferred shareholder owning 100 shares receive in 2021 if Sunshine pays $1,000,000 in dividends
Answers
Answer:
the amount of dividend that would be paid to the preferred shareholder is $2,100
Explanation:
The computation of the amount of dividend that would be paid to the preferred shareholder is shown below;
= Par value × dividend rate × number of shares × number of years
= $100 × 7% × 100 × 3 years
= $2,100
hence, the amount of dividend that would be paid to the preferred shareholder is $2,100
The same is to be relevant
For several years, Flame Corporation has had a current ratio that was consistent with the other companies in its industry. For most recent year, Flame's current ratio was significantly higher than that of the industry. What is the best possible explanation for this situation
Answers
Answer: b. Flowers liquidity has improved
Explanation:
The Current ratio is calculated by dividing the current assets of a company by its current liabilities. The current assets represent the liquidity of the company as they comprise of assets like cash and marketable securities.
If the current ratio was to increase, it would mean that either the numerator (current assets) increased or the denominator (current liabilities) decreased or that both happened. There is an option for the liquidity increasing which is saying that the numerator increases so this is correct as it is in line with what could have happened.
ABC's sales equal $60,000 and cost of goods sold equals $20,000. Its beginning inventory was $1,600 and its ending inventory is $2,400. ABC's inventory turnover ratio equals how many times a year?
A) 5 times.
B) 30 times.
C) 10 times.
D) 20 times.
Answers
Answer:
C) 10 times
Explanation:
Calculation to determine ABC's inventory turnover ratio equals how many times a year
Using this formula
Inventory turnover ratio =Cost of goods sold equals /Average inventory
Let plug in the formula
Inventory turnover ratio=$20,000/[($1,600+$2,400)/2]
Inventory turnover ratio=$20,000/($4,000/2)
Inventory turnover ratio=$20,000/$2,000
Inventory turnover ratio=10 times
Therefore ABC's inventory turnover ratio will equals 10 times a year
ABC's sales equal $60,000 and cost of goods sold equals $20,000. The, ABC's inventory turnover ratio equals to 10 times a year.
What is Inventory Turnover ratio?
Inventory turnover ration represents the total inventory that is sold, but and replaced by person. It can be calculated by dividing cost of goods sold by average inventory.
Calculation to determine ABC's inventory turnover ratio:-
Inventory turnover ratio =Cost of goods sold equals /Average inventory
Inventory turnover ratio=$20,000/[($1,600+$2,400)/2]
Inventory turnover ratio=$20,000/($4,000/2)
Inventory turnover ratio=$20,000/$2,000
Inventory turnover ratio=10 times
Therefore, correct option is C.
Learn more about inventory turnover ratio, refer to the link;
https://brainly.com/question/26172857
Which one of these equations is an accurate expression of the balance sheet? Assets ≡ Liabilities −Stockholders’ equity Stockholders’ equity ≡ Assets + Liabilities Liabilities ≡ Stockholders’ equity −Assets Assets ≡ Stockholders’ equity −Liabilities Stockholders’ equity ≡ Assets −Liabilities
Answers
Answer:
Stockholders’ equity ≡ Assets −Liabilities
Explanation:
The Balance Sheet equation is also known as the Accounting equation. It can be written in 3 ways as :
Assets = Equity + Liabilities
or
Equity = Assets - Liabilities
or
Liabilities = Assets - Equity
Hallie painted a picture and wanted to make it available for sale on the
Internet. How can she best protect her work from intellectual property theft?
O A. Hire a security guard
B. Hire an intellectual property lawyer
C. Add a watermark
a
O D. Change her password
Answers
Answer:
c adding a watermark they cannot remove it if they copy picture off the internet.
The correct option is C.
What does a watermark mean?Watermarking is the process of superimposing a logo or piece of text atop a document or image file, and it's an important process when it comes to both the copyright protection and marketing of digital works.
What is a watermark on a photo?A watermark is a logo, piece of text, or signature superimposed onto a photograph. Watermarks are typically transparent, so those viewing the image can still admire it. You can usually identify the photographer through the watermark, too.
Learn more about watermark here https://brainly.com/question/24206908
#SPJ2
Each of the following are advantages of bonds except: multiple choice bonds do not affect owner control bonds require payment of periodic interest and par value at maturity bonds can increase return on equity
Answers
Answer:
bonds require payment of periodic interest and par value at maturity bonds.
Explanation:
A bond can be defined as a debt or fixed investment security, in which a bondholder (investor or creditor) loans an amount of money to the bond issuer (government or corporations) for a specific period of time. The bond issuer are expected to return the principal (face value) at maturity with an agreed upon interest (coupon), which are paid at fixed intervals.
The disadvantages of bonds are listed below as;
1. Bonds typically require a payment of periodic interest.
2. Bonds require a payment of the principal amount.
3. Bonds can decrease a person's return on equity.
4. The payments of a bond by the bond issuer may become burdensome when cash flow and income are quite low.
Robo Hot Inc., is a company that markets electric heaters to hospitals. Mr. Heatmizer, it's CEO, would ike to reduce its inventory cost by determining the optimal number of electric heaters to obtain per order. The annual demand is 100,000 units and the ordering cost is $10 per order. The carrying cost per unit is $2.00. Using these figures, calculate the expected number of orders per year.
Answers
Answer:
Expected number of orders=31.6 orders per year
Explanation:
The expected number of orders would be the Annual demand divided by the economic order quantity(EOQ).
The Economic Order Quantity (EOQ) is the order quantity that minimizes the balance of holding cost and ordering cost. At the EOQ, the holding cost is exactly the same as the ordering cost.
It is calculated as follows:
EOQ = (2× Co D)/Ch)^(1/2)
Co- ordering cost Ch - holding cost, D- annual demand
EOQ = (2× 10 × 100000/2)^(1/2)= 3162.27 units
Number of orders = Annual Demand/EOQ
= 100,000/3,162.27= 31.62 orders
Expected number of orders=31.6 orders per year
What is the Net Present Value of the following cash flow streams at an interest rate of 8.25%: at year 0: $0; year 1: $75; year 2: $225; year 3: $0; and year 4: $300. $__.
Answers
Answer:
the net present value is $479.7743
Explanation:
The computation of the net present value is shown below:
= cash flow ÷ (1+interest rate)^number of years
= $75 ÷ (1.0825) + $225 ÷ (1.0825)^2 + $300 ÷ (1.0825)^4
= $479.7743
Hence, the net present value is $479.7743
We simply applied the above formula so that the correct amount could come
The present value of a future sum decreases as either the discount rate or the number of periods per year increases, other things held constant. True False
Answers
Answer:
True
Explanation:
At the time when the future sum of the present value reduced and it can be either the discount rate or the number of the period on a yearly basis increased being the other things would remain the same
So the given statement is true
Hence, the same should be considered and relevant too
Danielsen's has 15,000 shares of stock outstanding and projected annual free cash flows of $48,200, $57,900, $71,300, and $72,500 for the next four years, respectively. After that, the cash flows are expected to increase at a constant annual rate of 1.6 percent. What is the current value per share of stock at a discount rate of 15.4 percent
Answers
Answer:
$31.57 per share
Explanation:
Terminal Value (TV) = CF5(1 + g) / (Ke – g)
= $72,500*(1 + 0.0160) / (0.1540-0.0160)
= $73,660 / 0.1380
= $533,768
Year Cash Flow PVF at 15.40% PV of Free Cash Flow
1 48,200 0.866551 41,768
2 57,900 0.750911 43,478
3 71,300 0.650703 46,395
4 72,500 0.563867 40,880
4 533,768 0.563867 300,974
TOTAL 473,495
The current value per share of stock = Total Present value of future cash flows / Number of shares outstanding
= $473,495 / 15,000 shares outstanding
= $31.57 per share
The equity ownership of the units by the investors in a corporation is called shares. The current value per share at a discount rate of 15.4 % is $31.57.
What is terminal value?Terminal value (TV) is the expected cash value in a business, project, and asset that is estimated beyond the forecasted period. The terminal value is calculated as:
[tex]\rm TV =\rm \rm \dfrac{CF5(1 + g)}{(Ke - g)}[/tex]
Substituting values in the equation TV is calculated as:
[tex]\begin{aligned} &= \$72,500 \times \dfrac{(1 + 0.0160)}{(0.1540-0.0160)}\\\\&= \dfrac{\$73,660}{0.1380}\\\\&= \$533,768 \end{aligned}[/tex]
Check the attached image below for a table of the present value of the cash flow.
The current value is calculated as:
[tex]\begin{aligned}\text{The current value per share of stock} &= \dfrac{\text{Total Present value of future cash flows}}{\text{Number of shares outstanding}}\\\\&= \dfrac{\$473,495}{15,000 \;\rm shares \; outstanding}\\\\&= \$31.57 \;\rm per \; share\end{aligned}[/tex]
Therefore, $31.57 is the current value per share.
Learn more about cash flow here:
https://brainly.com/question/17192081
Brief Exercise 24-01 Wildhorse Company uses both standards and budgets. For the year, estimated production of Product X is 565,000 units. Total estimated cost for materials and labor are $1,243,000 and $1,638,500. Compute the estimates for (a) a standard cost and (b) a budgeted cost.
Answers
Answer and Explanation:
The computation is shown below:
a. The standard cost is
Fo material
= $1,243,000 ÷ 565,000 units
= $2.20 per unit
And, for labor it is
= $1,638,500 ÷ 565,000 units
= $2.90 per unit
b. The budgeted cost would be remian the same as the total cost i.e. $1,243,000 and $1,638,500
Hence, the same would be considered and relevant
The final phase of the systems development life cycle is systems ________. Select one: a. implementation b. maintenance c. operation d. design e. analysis
Answers
Answer:
b. maintenance
Explanation:
The systems development life cycle contains 5 steps i.e.
1. Planning
2. Analysis
3. Design
4. Implementation
5. Maintenance
The final phase is the maintenance & required regular updated. It occurs when the end users could fine the system in the case when they want to increase the performance, or add new capabilities or meeting extra user requirements so it can be done under this step
Financial statement data for the years 20Y5 and 20Y6 for Black Bull Inc. follow: 20Y5 20Y6 Net income $1,538,000 $2,485,700 Preferred dividends $50,000 $50,000 Average number of common shares outstanding 80,000 shares 115,000 shares a. Determine the earnings per share for 20Y5 and 20Y6. Round to two decimal places. 20Y5 20Y6 Earnings per Share $fill in the blank 1 $fill in the blank 2 b. Is the change in the earnings per share from 20Y5 to
Answers
Answer:
1. Earnings per share = (Net income - Preferred Dividend) / Average Common Stock EPS
Earnings per share 20Y5 = (1538000 - 50000) / 80000
Earnings per share 20Y5 = $18.60
Earnings per share 20Y6 = (2485700 - 50000) / 115000
Earnings per share 20Y6 = $21.18
2. The charnge in EPS is Favourable because there is increase in Earnings per share over the year.
ou own a portfolio that has $2,700 invested in Stock A and $3,800 invested in Stock B. Assume the expected returns on these stocks are 12 percent and 18 percent, respectively. What is the expected return on the portfolio
Answers
Answer:
the expected return on the portfolio is 15.50%
Explanation:
The computation of the expected return on the portfolio is shown below:
Total investment is
= $2,700 + $3,800
= $6,500
Now
Expected return of portfolio is
= ($2,700 ÷ $6,500) × 12 + ($3,800 ÷ $6,500) × 18
= 4.98% + 10.52%
= 15.50%
Hence, the expected return on the portfolio is 15.50%
If Larry does not know about the theft or any problems with the instrument, what is the status of Larry
Answers
Incomplete question. The full question read;
Bob writes a check to cash for $1000 to pay a bill from Acme. He then finds out that Acme breached the contract so he decides he will not pay them and puts a stop payment on the check. However, the check is stolen by Theron Thief (and Bob was not negligent) who then gives it to his landlord, Larry Landlord, to whom Theron already owes $1000. If Larry does not know about the theft or any problems with the instrument, what is the status of Larry:
1. Accommodation Indorser
2. Ordinary Holder
3. A Maker
4. Holder in Due Course
Answer:
4. Holder in Due Course
Explanation:
Under the provisions made by the law, basically when someone holds possession of a payment instrument such as a check without knowledge that the instrument has either been:
dishonored,or it has been altered, forged,or contain some irregularities, etc,This individual (Larry) who holds this payment instrument in good faith is termed the Holder in Due Course.
9. OMG Corporation just paid a $1.50 annual dividend on each share. It is planning on increasing its dividend by 15 percent a year for the next 4 years. The corporation will then decrease the growth rate to a rate of 4 percent per year, and keep it that way indefinitely. The required rate of return is 7.00 percent. Calculate the current value of one share of this corporation's stock.
Answers
The current value of one share of the corporation's stock is $76.59.
What is the value of the stock?The two-stage dividend model would be used to determine the value of the stock. In the two-stage dividend growth model, the first stage is characterised by a fast growth rate which becomes steady in the second stage.
Dividend in Y1 = 1.50 x 1.15 = 1.725Dividend in Y2 = 1.50 x 1.15^2 = 1.98Dividend in Y3 = 1.50 x 1.15^3 = 2.28Dividend in Y4 = 1.50 x 1.15^4 = 2.62Dividend in Y4 = (2.62 X 1.04) / (0.07 - 0.04) = 90.95Find the present value of these cash flows
Value of the stock = $76.59
To learn more about the two stage dividend model, please check: https://brainly.com/question/26564273
If demand for reserves is predected to increase temporarily, the manager of the trading desk at the New York Fed bank will likely conduct ________ open market operations to ________ reserves.
Answers
Answer:4.1
Explanation:
Assume that you manage a $10.00 million mutual fund that has a beta of 1.05 and a 9.50% required return. The risk-free rate is 4.20%. You now receive another $5.00 million, which you invest in stocks with an average beta of 0.65. What is the required rate of return on the new portfolio
Answers
Answer:
8.83%
Explanation:
The computation of the required return is shown below;
The market risk premium is
= 9.5% - 4.2% ÷ 1.05
= 5.048%
Now
beta of portifolio is
= 10 ÷ 15 × 1.05 + 5 ÷ 15 × 0.65
= 0.9167
And, finally
required return is
= 4.2% + 0.9167 × 5.048%
= 8.83%
Eastline Corporation had 11,000 shares of $10 par value common stock outstanding when the board of directors declared a stock dividend of 3,520 shares. At the time of the stock dividend, the market value per share was $14. The entry to record this dividend is:______.
a. Debit Retained Earnings $49.280 Credit Common Stock Dividend Distributable $49.280
b. No entry is needed
c. Debit Common Stock Dividend Distributable $49,280, credit Retained Earning 549.280.
d. Debit Retained Earnings $35200. cred Common Stock Dividend Distribble $35.200
e. Debit Retained Emming $49.280 credit Common Stock Dividend Darts $35.200, credit Peld in Capital in Bress of Par Value. Common Stock $14,080
Answers
Answer:
e. Debit Retained earning $49,280 Credit Common stock dividend distributable $35,200
Credit Paid in capital in excess of par value(Common stock) $14,080
Explanation:
The journal entry is as follows:
Retained earnings (3,520 shares × $14)
Dr $49,280
_______ Common stock dividend distributable (3,520 shares × $10)
Cr $35,200
_______ Paid in capital in excess of par value ($49,280 - $35,200)
Cr $14,080
The task force members had trouble at first but finally the tension subsided, roles became clear, and information began to flow between members. In what phase of team development is this task force
Answers
Answer:
Norming
Explanation:
Since in the question it is mentioned that the roles are very clear to the team members also the information is starting to flow so here the team development represent the norming phase of this task force as in this stage the performance of the team rised since the members are ready to learn &corporate and also begins to focus on the team goal and objectives
On January 1, 2021, Summer Fashions Corp. awarded restricted stock units (RSUs) representing 5 million of its $1 par common shares to key personnel, subject to forfeiture if employment is terminated within three years. After the recipients of the RSUs satisfy the vesting requirement, the company will distribute the shares. On the grant date, the shares had a market price of $9.00 per share. The journal entry to record the lifting of restrictions on the RSUs and issuing shares at December 31, 2023, would include a:
Answers
Answer:
Following are the journal entry to the given question:
Explanation:
Payment on stock capital limited 45
Stock Popular 5
Capital payments on surplus par 40
Which type of graphic organizer would best organize your notes on how to start a small business?
A). a timeline
B). a Venn diagram
C). problem-solution chart
D). a cluster diagram
Answers
Answer:
a Venn diagram
Explanation: