Salwid-Mort, a mortgage broker, has hired you to develop a spreadsheet they will use with their clients. They’ve noticed that thirty-year loans with an interest offset facility are popular with their clients. They want a spreadsheet that demonstrates some of the characteristics of this type of loan to their clients. Broadly, they’d like to show their clients a graph with three curves on it: one, the declining outstanding balance of a traditional principle and interest loan, two, as above, but with an interest offset facility, tracking fortnightly savings of $1000, and three, as above, but the client gives a fortnightly savings amount greater than $1 000. To achieve these objectives, you have been asked to develop the following. Develop a spreadsheet with at least two sheets. One sheet, titled ‘Inputs’ consists of the following.
1. The Salwid-Mort logo 2. CY21, the Australian 10-year government bond yield for calendar year 2021 (i.e., the 10-year government bond yield on 31 December 2021, a j2 rate)* 3. The rate of interest for the 30-year mortgage, given by 130 basispoints over CY21 4. The initial loan amount, $1 000 000 5. The fortnightly cash deposit amount of $1 000 6. A second, higher (than $1 000), fortnightly cash deposit amount. One sheet, titled ‘Graphs’ consists of the following a line graph, with three curves. The curves are as follows. 1. The outstanding balance of the loan, with no offset (i.e., a traditional principle and interest loan). 2. The outstanding balance of the loan with an offset facility (described below) generated by saving $1 000 a fortnight. 3. The outstanding balance of the loan with an offset facility generated by saving more than $1 000 a fortnight. * [15 marks] The axes should be labelled: ‘Loan balance’ (vertical axis) and ’Time elapsed’ (horizontal axis, in years). The graph should include a legend, indicating which curve is which. In doing your calculations, note the following. 1. Treat the loan as running for 24 fortnightly (evenly spaced) periods each year over 30 years. 2. Deposits to the savings account are made at the end of each fortnightly period. They can be either $1 000 or a higher amount. 3. The initial balance of the savings account is zero. 4. The savings account earns compound interest at an effective annual rate equivalent to the mortgage rate (given above). 5. The interest offset facility is modelled as follows: the interest earnings at the end of each fortnight are credited towards the loan—and so the savings account no longer accumulates with interest. 6. The loan starts with an outstanding balance of $1 000 000. Interest is charged at the end of each fortnight, when a loan repayment is also made. The repayment is at a level to extinguish the loan after thirty years at the given mortgage rate (ignoring any interest offset facility). 7. If the interest offset facility is operating, then, at the end of each fort- night, the interest from the savings account is credited towards the loan.

Answers

Answer 1

The spreadsheet will provide Salwid-Mort's clients with a visual representation of the benefits of using an interest offset facility, as well as the impact of different fortnightly savings amounts on the outstanding balance of the loan over time.

How did we arrive at this assertion?

To create the said spreadsheet, we will need two sheets. The first sheet will be called "Inputs," and it will contain all of the necessary inputs for the calculation. The second sheet will be called "Graphs," and it will contain the graph with the three curves.

In the Inputs sheet, we will include the Salwid-Mort logo, followed by the necessary inputs:

CY21, the Australian 10-year government bond yield for calendar year 2021 (i.e., the 10-year government bond yield on 31 December 2021, a j2 rate)*The rate of interest for the 30-year mortgage, given by 130 basis points over CY21The initial loan amount, $1,000,000The fortnightly cash deposit amount of $1,000A second, higher (than $1,000), fortnightly cash deposit amount.

*Note: We will assume that the CY21 value has been provided to us and will not be calculated in this spreadsheet.

In the Graphs sheet, we will create a line graph with three curves. The curves will represent:

The outstanding balance of the loan, with no offset (i.e., a traditional principal and interest loan).The outstanding balance of the loan with an offset facility generated by saving $1,000 a fortnight.The outstanding balance of the loan with an offset facility generated by saving more than $1,000 a fortnight.The vertical axis will be labeled "Loan balance," and the horizontal axis will be labeled "Time elapsed" (in years). The graph will include a legend, indicating which curve is which.

To calculate the outstanding balance of the loan, we will use the following formula:

Outstanding balance = Initial loan amount * ((1 + r/2)^n - (1 + r/2)^p) / ((1 + r/2)^n - 1)

where:

r is the interest rate for the 30-year mortgage, given by 130 basis points over CY21

n is the total number of fortnights over 30 years (24 fortnightly periods each year over 30 years)

p is the number of fortnights elapsed

The fortnightly cash deposit amount will be added to the savings account at the end of each fortnight

The savings account earns compound interest at an effective annual rate equivalent to the mortgage rate

If the interest offset facility is operating, then, at the end of each fortnight, the interest from the savings account is credited towards the loan

We will use the PMT function in Excel to calculate the loan repayment required to extinguish the loan after thirty years at the given mortgage rate (ignoring any interest offset facility).

Once we have calculated the outstanding balance of the loan for each curve, we can plot the three curves on the graph in the Graphs sheet.

Overall, the spreadsheet will provide Salwid-Mort's clients with a visual representation of the benefits of using an interest offset facility, as well as the impact of different fortnightly savings amounts on the outstanding balance of the loan over time.

learn more about spreadsheet: https://brainly.com/question/4965119

#SPJ1


Related Questions

a 10 year bond has a yield to maturity of 9.50 percent and a modified duration of 6 years. if the market yield increases by 50 basis points, what would the change in the bond's price be?

Answers

The change in the bond's price would be approximately -3.00%.

To calculate the change in the bond's price, use the modified duration and the change in yield.

1. Identify the modified duration: 6 years
2. Identify the initial yield to maturity: 9.50%
3. Determine the change in yield: 50 basis points (0.50%)
4. Multiply the modified duration by the change in yield: 6 * 0.50% = 3.00%
5. Since the yield increased, the bond's price will decrease, so the change is negative: -3.00%

The bond's price will decrease by approximately 3.00% when the market yield increases by 50 basis points.

To know more about yield to maturity click on below link:

https://brainly.com/question/30676637#

#SPJ11

Question 20 (3.3 points) Saved Robert constantly makes money on his stock investments by analyzing financial statements. This piece of evidence does not violate market efficiency. A) The semistrong-fo rm B) The weak-form C) All forms of D) The strong form

Answers

Saved Robert constantly makes money on his stock investments by analyzing financial statements. This piece of evidence does not violate market efficiency is B. the weak-form.

The weak-form of market efficiency states that all past trading information, such as stock prices and volume, is already reflected in current stock prices. Therefore, investors cannot consistently generate excess returns by analyzing historical price patterns. However, the weak-form does not account for fundamental analysis, which involves examining financial statements and other company-related information. In contrast, the semi-strong form of market efficiency suggests that all publicly available information, including financial statements, is already incorporated into stock prices. If the market were semi-strong form efficient, Robert would not be able to consistently make money through financial statement analysis.

The strong form of market efficiency posits that all information, public and private, is reflected in stock prices, making it even more difficult for investors like Robert to consistently generate excess returns. In conclusion, Robert's success in stock investments by analyzing financial statements does not violate the weak-form of market efficiency, as it only considers past trading information and not fundamental analysis. Saved Robert constantly makes money on his stock investments by analyzing financial statements. This piece of evidence does not violate market efficiency is B. the weak-form.

Learn more about fundamental analysis at:

https://brainly.com/question/31412886

#SPJ11

some economists argue that regional free trade agreements will provide global benefits only if

Answers

Some economists argue that regional free trade agreements will provide global benefits only if trade creation exceeds trade diversion.

Free trade agreements (FTAs) are agreements reached between two or more countries on a range of topics, such as investor protections, intellectual property rights, and responsibilities influencing trade in goods and services. It could require keeping more records to be able to receive FTA benefits for your product, but it could provide it a competitive edge against products from other countries.

Each FTA has unique features, but they all generally have the same goal of lowering trade barriers and promoting more secure and open business and investment environments. Free trade agreements (FTAs) make it possible for American exporters and manufacturers to gain greater access to other markets. Tariffs are decreased or eliminated, trade barriers are removed through bilateral and global agreements, and economic growth is promoted.

Learn more about Trade Barriers here:

https://brainly.com/question/1326741

#SPJ4

You just won the grand prize in a national writing contest! As your prize, you will receive $2,000 a month for ten years. If you can earn 7 percent on your money, what is this prize worth to you today?
A. $172,252.71
B. $178,411.06
C. $181,338.40
D. $185,333.33
E. $190,450.25

Answers

The value of the prize is worth $185,333.33 today. This is because the prize is $2,000 a month for ten years, so it totals $240,000.

When that amount is adjusted for the 7 percent interest rate, it comes to $185,333.33. This amount is calculated by taking the original amount and multiplying it by the present value of an annuity factor.

The factor takes into account the time value of money, which means that money today is worth more than money in the future due to the potential for it to earn interest over time. Therefore, the prize of $240,000 a decade from now is worth less than $240,000 today, when factoring in the 7 percent interest rate.

Know more about annuity factor here

https://brainly.com/question/27894384#

#SPJ11

tcpa regulation, lead gen advertiser tend to shift to lead-to-sales, lead-to-installation. why? how does it works

Answers

The TCPA (Telephone Consumer Protection Act) regulation has strict rules regarding the use of automated phone calls, text messages, and faxes for marketing purposes. This has led lead generation advertisers to shift their focus to lead-to-sales and lead-to-installation strategies.

TCPA (Telephone Consumer Protection Act) regulations are in place to protect consumers from unwanted telemarketing calls, faxes, and text messages.

Because of these regulations, lead gen advertisers have shifted their focus from generating leads solely for marketing purposes to generating leads for sales and installation. In lead-to-sales, advertisers focus on generating leads that are more likely to convert into sales. This means they may target specific demographics or use more personalized messaging to increase the chances of a sale. In lead-to-installation, advertisers focus on generating leads for products or services that require installation, such as home security systems or solar panels. This can lead to higher quality leads that are more likely to result in a sale.Overall, these strategies work by targeting more specific audiences and tailoring the messaging to their needs and interests. By doing so, advertisers can increase the likelihood of a sale and comply with TCPA regulations.
This shift to lead-to-sales and lead-to-installation works by focusing on acquiring customers who are more likely to make a purchase or request installation services. This allows advertisers to focus their efforts on high-quality leads that are more likely to convert, ultimately improving their return on investment.

In summary, lead gen advertisers are shifting to lead-to-sales and lead-to-installation strategies due to TCPA regulations to ensure compliance and improve their targeting of high-quality leads, which results in a better return on investment.

Learn more about telemarketing here: https://brainly.com/question/28052383

#SPJ11

You are given information for a delta-hedged portfolio for European options that you have written. For each scenario, compute the number of shares to buy or sell (indicate which action to take) on day 1 to maintain the delta-hedge for a portfolio of one option.
Stock Price Call premium Call delta (A)
Day 0 55 6.50 0.4
Day 1 60 9.50 0.6
Stock Price Put premium Put Elasticity()
Day 0 50 1.00 -5
Day 1 49 0.91 -7

Answers

To maintain the delta-hedge for a portfolio of one European call option, you should buy 0.6 shares on Day 1.


The call delta on Day 0 is 0.4, and on Day 1 it's 0.6. The change in delta (∆delta) is 0.6 - 0.4 = 0.2. Since you have written one option, you need to buy 1 × 0.2 = 0.2 shares to maintain the delta-hedge.

However, since the question asks for maintaining the hedge for a portfolio of one option, it means you need to consider the initial 0.4 delta as well. Thus, you should buy 0.4 + 0.2 = 0.6 shares on Day 1.

To maintain the delta-hedge for a portfolio of one European put option, you should sell 7 shares on Day 1.


The put elasticity on Day 0 is -5, and on Day 1 it's -7. The change in elasticity (∆elasticity) is -7 - (-5) = -2. Since you have written one option, you need to sell 1 × 2 = 2 shares to maintain the delta-hedge.

However, since the question asks for maintaining the hedge for a portfolio of one option, it means you need to consider the initial -5 elasticity as well. Thus, you should sell -5 + (-2) = -7 shares on Day 1.

To know more about portfolio click on below link:

https://brainly.com/question/29333981#

#SPJ11

assume that an investor owns 124 shares of $12 par value common stock of a company and the company has a 2-for-1 stock split when the market price per share is $46. required: how many shares of common stock will the investor own after the stock split? what will probably happen to the market price per share of the stock? what will probably happen to the par value per share of the stock?

Answers

The par value per share of the stock will probably decrease to: $6 after the stock split.


1. The investor initially owns 124 shares of $12 par value common stock.


2. The company has a 2-for-1 stock split when the market price per share is $46.

To determine how many shares the investor will own after the stock split, we can simply multiply the initial number of shares by the split ratio (2-for-1):

124 shares x 2 = 248 shares

So, the investor will own 248 shares of common stock after the 2-for-1 stock split.

As for the market price per share after the stock split, it will likely decrease. This is because the total market value of the company remains the same, but the number of shares has doubled. Typically, the price per share will decrease to roughly half of the original price:

$46 / 2 = $23 (approximately)

Therefore, the market price per share of the stock will probably decrease to around $23 after the stock split.

Regarding the par value per share of the stock, it will also likely decrease following the stock split. This is because the total par value of the company's shares remains constant, but the number of shares has doubled. In a 2-for-1 stock split, the par value per share will be divided by 2:

$12 / 2 = $6

To know more about par value, refer here:

https://brainly.com/question/31390364#

#SPJ11

Your client wants to prepay $15 million in notes, which bear interest at a fixed rate of 7.5% per annum, payable quarterly. The notes do not provide for any payments of principal other than at maturity and there are 27 months until maturity. The Note Purchase Agreement provides for the payment of a "Make-Whole Amount" in the vent of prepayment of principal. This is an amount, not less than zero, which is the amount by which (i) the present value of all remaining payments of principal and interest that would be due with regard to the amount of principal that is be prepaid, discounted to the present date by a "Reinvestment Yield," exceeds (ii) the amount of principal that is being prepaid. The "Reinvestment Yield" is equal to the sum of (a) 75 basis points plus (y) the yield to maturity implied by the U.S. Treasury yields for the remaining contractual term of the principal being paid. The current implied US Treasury yield for obligations with 27 months remaining in their term is 2.45%.What is the applicable Make-Whole Amount that is due in connection with the prepayment? Show the Excel formula you used to compute the answer.

Answers

The applicable Make-Whole Amount that is due in connection with the prepayment is $1,316,485.95.

The Excel formula used to compute this is: =max(0, (PV((0.075/4), 274, -15000000)(0.0245+0.0075/4+1)-15000000))

To calculate the Make-Whole Amount, we need to find the present value of all remaining payments of principal and interest that would be due with regard to the amount of principal that is to be prepaid, discounted to the present date by a "Reinvestment Yield," and then subtract the amount of principal being prepaid.

First, we calculate the Reinvestment Yield, which is equal to the sum of (a) 75 basis points plus (b) the yield to maturity implied by the U.S. Treasury yields for the remaining contractual term of the principal being paid.

So, the Reinvestment Yield is:

= 0.0245 + 0.0075/4

= 0.026875

Next, we calculate the present value of all remaining payments of principal and interest using the PV function in Excel:

PV((0.075/4), 274, -15000000) = $15,869,334

Finally, we calculate the Make-Whole Amount by multiplying the present value by the Reinvestment Yield plus 1, and then subtracting the amount of principal being prepaid:

= 15,869,334 (0.026875 + 1) - 15,000,000

= $1,316,485.95

Since the Make-Whole Amount cannot be less than zero, the final formula used in Excel is =max(0, (PV((0.075/4), 274, -15000000)(0.0245+0.0075/4+1)-15000000)).

Learn more about present value: https://brainly.com/question/20813161

#SPJ11

The Meldrum Co. expects to sell 3,000 units, ± 15 percent, of a new product. The variable cost per unit is $8, ± 5 percent, and the annual fixed costs are $12,500, ± 5 percent. The annual depreciation expense is $4,000 and the sale price is $18 a unit, ± 2 percent. The project requires $24,000 of fixed assets which will be worthless when the project ends in six years. Also required is $6,500 of net working capital for the life of the project. The tax rate is 21 percent and the required rate of return is 12 percent. What is the net present value of the pessimistic scenario?
A. $13,810.29
B. $14,008.16
C. $12,979.40
D. $8,308.15
E. $10,146.18

Answers

The net present value of the pessimistic scenario is -$22,191.85. The answer is not one of the choices given.

To calculate the net present value (NPV) of the pessimistic scenario, we need to follow these steps:

1: Calculate the pessimistic values of the variables.

Sales volume: 3,000 - 15% = 2,550 units

Variable cost per unit: $8 + 5% = $8.40

Fixed costs: $12,500 - 5% = $11,875

Sale price: $18 - 2% = $17.64

2: Calculate the annual cash flows.

Revenue = Sales volume x Sale price

= 2,550 x $17.64

= $45,074.40

Variable costs = Sales volume x Variable cost per unit

= 2,550 x $8.40

= $21,420

Contribution margin = Revenue - Variable costs

= $45,074.40 - $21,420

= $23,654.40

Fixed costs = Annual fixed costs + Depreciation expense

= $11,875 + $4,000

= $15,875

Operating income before taxes = Contribution margin - Fixed costs

= $23,654.40 - $15,875

= $7,779.40

Taxes = Operating income before taxes x Tax rate

= $7,779.40 x 21%

= $1,633.27

Net income = Operating income before taxes - Taxes

= $7,779.40 - $1,633.27

= $6,146.13

Annual cash flow = Net income + Depreciation expense

= $6,146.13 + $4,000

= $10,146.13

3: Calculate the present value of each annual cash flow.

where PV is the present value, CF is the cash flow, r is the required rate of return, and n is the number of years.

Year 0:

Initial investment = Fixed assets + Net working capital

= $24,000 + $6,500

= $30,500

PV0 = -$30,500 (negative because it's a cash outflow)

Year 1-6:

= $8,308.15

4: Calculate the net present value.

NPV = PV0 + PV1-6

= -$30,500 + $8,308.15

= -$22,191.85

For more such questions on present value, click on:

https://brainly.com/question/20813161

#SPJ11

how long will it take for vermont to double its economy if it maintains this growth rate? give your answer to two decimals.

Answers

The main agricultural products from this state are those related to nurseries and greenhouses. Vermont is the nation's №1 producer of maple syrup.

What is economy of Vermont?

Vermont's GDP increased by 0.5% from 2021 to $30.2 billion in 2022. Over the five years leading up to 2022, Vermont's GDP increased at an annualised rate of 1.8%. In addition, Vermont is ranked 41st out of the 50 US states for GDP growth during the previous five years.

A country's economy doubles in size during the course of how many years it takes to expand by its percentage growth rate, divided by 70. For instance, if an economy expands at 1% year, it will take 70 / 1 = 70 years for that economy to double in size.

Subtract the growth rate from 70 and double the result. The number of years needed to double is the outcome.

Learn more about economy of Vermont:

https://brainly.com/question/13478563

#SPJ1

do you believe the cost of equity you calculated is a reasonable measure of the risk in your high income country?

Answers

Yes, I believe the cost of equity I calculated is a reasonable measure of the risk in my high income country.

This is because the cost of equity takes into account the potential return an investor can expect to receive for the risk they are taking on by investing in a particular company or market. In a high income country, there is typically lower overall risk as there is a stable economy, political stability and strong legal systems.

Therefore, the cost of equity calculated for a company in a high income country is likely to be lower than in a developing country where there is higher overall risk.

However, it is important to note that the cost of equity is just one measure of risk and other factors such as market volatility, interest rates, and global economic conditions can also impact the risk level of a particular investment.

To know more about interest rates click on below link:

https://brainly.com/question/13324776#

#SPJ11

1) Why is a change in required yield for a preferred stock likely to have a greater impact on price than a change in required yield for bonds?
2) These valuation models are based on investors’ required rates of return and their reflection in the prices of the assets. Does the change in price always occur according to the model?

Answers

1) A change in required yield for a preferred stock is likely to have a greater impact on price than a change in required yield for bonds because preferred stocks have characteristics of both stocks and bonds.

They have fixed dividend payments like bonds, but also have the potential for appreciation like stocks. Therefore, changes in required yield will have a greater impact on the perceived risk and return of preferred stocks, causing a larger change in price.

2) The change in price does not always occur according to the model because valuation models are based on investors' assumptions and expectations, which can change rapidly due to various factors such as economic events, news, and market sentiment.

Additionally, market efficiency can cause prices to quickly adjust to new information, which may result in prices deviating from the valuation model. Therefore, while valuation models provide a framework for understanding asset prices, they are not always accurate predictors of actual prices.

To know more about valuation model click on below link:

https://brainly.com/question/28962032#

#SPJ11

Use two methods including formula and various Excel functions to solve the following problem:
Calculate the duration for a $1000, 4-year bond with a 6% annual coupon, currently selling at par. Use the duration to estimate the percentage change in the bond’s price for a decrease in the market interest rate to 4%. Use the bond price volatility equation to compute the bond price volatility. Compare the result with the estimated percentage change in the bond price.

Answers

Bond Price Volatility is $73.51.

Duration can be calculated using the following formula:

Duration = (PV of Cash Flows × Time) / Bond Price

where,

PV of Cash Flows = Present Value of all Cash Flows

Time = Time to receipt of Cash Flows in years

The cash flows for this bond would be:

Year 1: $60 coupon

Year 2: $60 coupon

Year 3: $60 coupon

Year 4: $1060 (coupon plus principal)

The present value of these cash flows can be calculated using the present value formula:

[tex]PV = CF / (1+r)^n[/tex]

where,

CF = Cash Flow

r = discount rate

n = time to receipt of cash flow

For this bond, assuming a discount rate of 6%, the present value of cash flows would be:

[tex]PV of Year 1 coupon = $60 / (1+0.06)^1 = $56.60\\PV of Year 2 coupon = $60 / (1+0.06)^2 = $53.50\\PV of Year 3 coupon = $60 / (1+0.06)^3 = $50.47\\PV of Year 4 coupon and principal = $1060 / (1+0.06)^4 = $820.11[/tex]

Therefore, the PV of Cash Flows = $980.68

The Time to receipt of Cash Flows = 1, 2, 3, and 4 years

Using the formula above, we can calculate the duration:

Duration = ($980.68 × 1 + $980.68 × 2 + $980.68 × 3 + $980.68 × 4) / $1000

Duration = 3.827 years

To estimate the percentage change in the bond’s price for a decrease in the market interest rate to 4%, we can use the following formula:

% Change in Bond Price = - Duration × Change in Yield

where,

Change in Yield = New Yield - Old Yield

In this case, the change in yield would be 6% - 4% = 2%.

% Change in Bond Price = - 3.827 × 2% = -7.654%

Therefore, the estimated percentage change in the bond price would be a decrease of 7.654%.

To compute the bond price volatility using the bond price volatility equation, we can use the following formula:

Bond Price Volatility = Duration × Bond Price × (Change in Yield / (1 + Yield))

In this case, assuming a yield of 6%, the bond price volatility would be:

Bond Price Volatility = 3.827 × $1000 × (2% / (1 + 6%)) = $73.51

To know more about bond refer to-

https://brainly.com/question/29667007

#SPJ11

price reductions offered on products and services to stimulate demand during off-peak seasons are referred to as

Answers

Price reductions offered on products and services to stimulate demand during off-peak seasons are referred to as seasonal discounts.


Seasonal discounts are a common marketing strategy used by businesses to boost sales and generate more revenue during periods when demand for their products or services is typically low. By offering these price reductions, companies aim to attract customers who may be hesitant to make a purchase due to budget constraints or lack of interest. The reduced prices can also incentivize consumers to try out new products or services they might not have considered otherwise.


To implement seasonal discounts, businesses first identify their off-peak seasons, which may vary depending on the industry and location. For example, a ski resort may offer discounted rates during the summer months, while a clothing retailer might provide lower prices for winter apparel in the spring.


Once the off-peak season has been identified, businesses determine the appropriate discount rates and promotions to offer. These could include percentage discounts, fixed-price reductions, or bundle deals that encourage consumers to purchase multiple items or services at a discounted rate.


To ensure the success of the seasonal discounts, businesses must effectively communicate their promotions to potential customers. This can be done through various marketing channels, such as social media, email campaigns, and in-store advertisements.



In conclusion, seasonal discounts are a strategic way for businesses to stimulate demand during off-peak seasons by offering price reductions on their products and services. By identifying the right times to implement these discounts and promoting them effectively, companies can attract more customers, increase sales, and maintain a steady revenue stream throughout the year.

To know more about Price reductions refer here:

https://brainly.com/question/10755115#

#SPJ11

A company reports the following information for its first year of operations: Units produced this year 650 units Units sold this year 500 units Direct materials $750 per unit Direct labor $1,000 per unit Variable overhead ? in total Fixed overhead $308,750 in total If the company's cost per unit of finished goods using variable costing is $2,375, what is total variable overhead? $237,500 $75,000 $312,500 $406,250 $97,500

Answers

total variable overhead is $406,250 . The correct answer is option D.

To calculate the total variable overhead, we can use the formula for variable costing, which is: Variable Cost per Unit = Direct Materials + Direct Labor + Variable Overhead

We are given that the cost per unit of finished goods using variable costing is $2,375. We also know that the direct materials cost is $750 per unit and the direct labor cost is $1,000 per unit.

Substituting these values into the formula, we get:$2,375 = $750 + $1,000 + Variable Overhead.Solving for Variable Overhead, we get:Variable Overhead = $2,375 - $750 - $1,000 = $625

Since we want the total variable overhead, we need to multiply this amount by the number of units produced, which is 650. Total Variable Overhead = Variable Overhead per Unit x Units Product.Total Variable Overhead = $625 x 650 = $406,250 . Therefore, the answer is option D: $406,250.

To know more about total variable,refer to the link:

https://brainly.com/question/28013522#

#SPJ11

Royal, Inc., is considering a change in its cash-only sales policy. The new terms of sale would be net one month. The required return is 64 percent per month. Current Policy New Policy Price per unit $ 780 $ 780Cost per unit $ 570 $ 570 Unit sales per month 840 890Calculate the NPV of the decision to switch. (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) NPV $_______

Answers

The NPV of switching from the current cash-only sales policy to the new net one-month policy is -$84,787.80.

How to calculate the net present value (NPV) for a company?

To calculate the NPV of the decision to switch from the current cash-only sales policy to the new net one-month policy, we need to compare the present value of the cash inflows and outflows associated with each policy.

Under the current policy, Royal, Inc., receives cash of $780 per unit sold, and incurs a cost of $570 per unit sold. Therefore, the cash inflow per unit is $780 - $570 = $210. Multiplying this by the number of units sold per month (840), we get a total monthly cash inflow of $176,400.

Under the new policy, Royal, Inc., will receive cash of $780 per unit sold one month after the sale, and will continue to incur a cost of $570 per unit sold at the time of sale.

Therefore, the cash inflow per unit under the new policy is $0 in the first month and $780 in the second month. Multiplying the number of units sold per month (890) by the second-month cash inflow per unit ($780), we get a total monthly cash inflow of $695,400 in the second month.

However, we need to discount this amount back to present value using the required return of 64% per month.

Therefore, the present value of the second-month cash inflow is:

PV = $695,400 / (1 + 0.64) = $422,512.20

The net cash outflow under the new policy is the cost of goods sold ($570) multiplied by the number of units sold per month (890) in the first month. Therefore, the net cash outflow is:

$570 × 890 = $507,300

The NPV of the decision to switch to the new policy is the present value of the second-month cash inflow minus the net cash outflow in the first month:

NPV = PV of second-month cash inflow - net cash outflow in first month

NPV = $422,512.20 - $507,300

NPV = -$84,787.80

Therefore, the NPV of the decision to switch to the new policy is -$84,787.80. This suggests that switching to the new policy is not a profitable decision for the company.    

Learn more about the NPV of the decision.

brainly.com/question/31387789

#SPJ11

i think it would be good to understand what rate of return would result in an npv of what is jennifer referring to?

Answers

Jennifer is likely referring to the net present value (NPV) of a project or investment. The NPV is a calculation that takes into account the present value of expected future cash flows and compares it to the initial investment.

The goal is to determine if the project is financially viable and if it will generate a positive return on investment. To determine what rate of return would result in a specific NPV, you would need to use a financial calculator or spreadsheet software to run different scenarios.

You would input the initial investment, expected cash flows, and discount rate (the rate of return required to make the investment worthwhile) to determine the NPV. Then you could adjust the discount rate until you reach the desired NPV.

It's important to note that the discount rate used in the NPV calculation should reflect the risk associated with the project or investment. Higher-risk projects or investments would require a higher discount rate to compensate for the uncertainty.

You can learn more about net present value at: brainly.com/question/29669538

#SPJ11

An investor has two bonds in her portfolio, Bond C and Bond Z. Each bond matures in 4 years, has a face value of $1,000, and has a yield to maturity of 8.2%. Bond C pays a 11.5% annual coupon, while Bond Z is a zero coupon bond.
a.Assuming that the yield to maturity of each bond remains at 8.2% over the next 4 years, calculate the price of the bonds at each of the following years to maturity. Round your answer to the nearest cent.
Years to Maturity Price of Bond C Price of Bond Z
4 $ $
3 $ $
2 $ $
1 $ $
0 $ $

Answers

Price of Bond C:

4 years to maturity: $1,194.87

3 years to maturity: $1,145.47

2 years to maturity: $1,097.63

1 year to maturity: $1,051.32

0 years to maturity: $1,000.00

Price of Bond Z:

4 years to maturity: $820.08

3 years to maturity: $675.56

2 years to maturity: $552.28

1 year to maturity: $447.63

0 years to maturity: $367.47

The price of a bond is determined by the present value of its future cash flows, which is calculated using the bond's yield to maturity. For Bond C, the annual coupon payments of $115 ($1,000 x 11.5%) are discounted.

Using the yield to maturity of 8.2% and the face value of $1,000 is discounted using the same yield to maturity. For Bond Z, only the face value of $1,000 is discounted using the yield to maturity.

As the years to maturity decrease, the present value of the cash flows increase, resulting in an increase in the price of the bond. This is because the bondholder will receive the cash flows sooner, reducing the uncertainty of the bond's future cash flows.

For more questions like cash visit the link below:

https://brainly.com/question/15709517

#SPJ11

steve's tentative minimum tax (tmt) for 2022 is $244,200. note: leave no answer blank. enter zero if applicable. required: what is his amt if his regular tax is $227,700? what is his amt if his regular tax is $265,500?

Answers

if Steve's regular tax for 2022 is $265,500, and his TMT is $244,200, he will owe the IRS $265,500, since this is the higher of the two amounts. In this scenario, Steve's regular tax exceeds his TMT, so he will only pay the regular tax amount.

Steve's tentative minimum tax (TMT) is a minimum tax that ensures that individuals who have significant deductions or use tax shelters still pay a minimum amount of tax. The TMT is calculated separately from the regular tax, and the higher of the two amounts is the amount owed to the IRS.

If Steve's regular tax for 2022 is $227,700, and his TMT is $244,200, he will owe the IRS $244,200, since this is the higher of the two amounts. The regular tax is calculated based on taxable income and applicable tax rates, while the TMT is calculated based on a set of alternative tax rules that limit certain deductions and credits.

It's important to note that the TMT is a complex tax calculation and can vary depending on an individual's circumstances. It's also subject to change each year based on inflation adjustments and changes to the tax code. Taxpayers who believe they may be subject to the TMT should consult with a tax professional to ensure they are properly calculating their tax liability.

To learn more about tentative minimum tax

https://brainly.com/question/15056544

#SPJ4

Your employer asks you to run some errands. The reimbursement rate is $0.54 per mile. You drive 6.5 miles. How much will the reimbursement be?
$8.31
$4.57
$3.51
$12.04

Answers

If your employer asks you to run some errands, you may be eligible for reimbursement for the expenses incurred during your work. In this case, your employer has stated that the reimbursement rate is $0.54 per mile. You have driven a total of 6.5 miles while running these errands.

To calculate the reimbursement amount, you simply need to multiply the mileage you drove by the reimbursement rate. Therefore, $0.54 x 6.5 = $3.51. This means that your reimbursement amount for driving 6.5 miles will be $3.51.

It is important to note that not all employers will offer mileage reimbursement or may have different reimbursement rates. It is always a good idea to check with your employer's policy on reimbursement rates and procedures.

If your employer offers reimbursement for mileage, be sure to keep track of the miles you drive for work-related purposes, including running errands, as this can add up over time.

In conclusion, in this scenario, your reimbursement for driving 6.5 miles for work-related errands will be $3.51 at a reimbursement rate of $0.54 per mile.

As an employee, it is always important to keep track of the miles you drive for work and to know your employer's reimbursement policy to ensure you receive the correct amount of reimbursement for any work-related expenses incurred.

To know more about employer refer here

https://brainly.com/question/1361941#

#SPJ11

business firms that compete with each other not only in one business unit, but in a number of related business units are said to be engaging in

Answers

Business firms that compete with each other not only in one business unit, but in a number of related business units are said to be engaging in "related diversification".

Related diversification is a strategy used by companies to expand their operations by entering into businesses that are related to their existing business. This allows them to leverage their existing resources, capabilities, and knowledge in new markets and product lines.

For example, a company that produces and sells smartphones may also enter the tablet market, leveraging its expertise in mobile devices to expand its product portfolio. Similarly, a company that produces and sells sports apparel may also enter the fitness equipment market, leveraging its brand and distribution network to expand into a related business.

The advantage of related diversification is that it allows companies to achieve economies of scale, reduce risk through diversification, and share resources across different business units. However, it also requires careful management to ensure that the different business units are integrated effectively and that the company's overall strategy is coherent and consistent.

You can learn more about diversification at

https://brainly.com/question/417234

#SPJ11

Recommendation for Government borrowing
1) Write a report on the topic with bullet points and a brief
explanation of each point

Answers

Recommendations for Government Borrowing are to Maintain a sustainable debt-to-GDP ratio, Diversify sources of borrowing, Utilize long-term borrowing, Prioritize productive investments, Monitor and manage fiscal risks, etc.

1. Maintain a sustainable debt-to-GDP ratio
- The government should aim to keep its debt levels manageable compared to the size of its economy, as a high debt-to-GDP ratio may lead to reduced investor confidence and increased borrowing costs.

2. Diversify sources of borrowing
- To reduce dependency on a single source of funding and minimize risks, the government should explore various borrowing options, including issuing bonds, obtaining loans from international organizations, and borrowing from other countries.

3. Utilize long-term borrowing
- Long-term borrowing can help the government to lock in lower interest rates, providing more predictable debt servicing costs and allowing for better planning of future spending and investment.

4. Implement a robust debt management strategy
- A well-defined debt management strategy can help the government minimize borrowing costs, manage risks, and ensure timely debt servicing. This may include developing a debt management office to oversee and coordinate borrowing activities.

5. Prioritize productive investments
- Government borrowing should be directed towards productive investments, such as infrastructure development, education, and healthcare, which can promote long-term economic growth and improve living standards.

6. Enhance transparency and accountability
- To maintain trust and credibility among investors, the government should provide regular and accurate information about its borrowing activities and debt levels, and demonstrate responsible fiscal management.

7. Monitor and manage fiscal risks
- The government should identify and assess potential fiscal risks, such as economic downturns, natural disasters, or changes in global financial conditions, and develop contingency plans to mitigate their impact on debt levels and borrowing costs.

By following these recommendations, government borrowing activities can be conducted responsibly and contribute to sustainable economic growth and development.

To know more about Government Borrowing refer here:

https://brainly.com/question/29871343#

#SPJ11

distinguish between common-law liability and statutory liability for auditors. what is the basis for the difference in liability?

Answers

A Liability is defined as a unborn loss of profitable benefits that an reality is needed to give to another reality as a result of once deals or other once events.

Common law liability arises from the legal opinions of judges in deciding a case, a precedent that serves as a companion for other judges to decide future analogous cases and is used in civil action.

On the other hand, legal liability reflects laws legislated at the state or civil position and prescribes certain procedures.

May involve civil or felonious liability. Liability is an obligation or liability to another that's extinguished by the unborn transfer or use of goods, the provision of services or any other profitable sale at a specific or determinable time, upon the circumstance of a specific event or on demand.

To know more about Liability,

brainly.com/question/28391469

#SPJ4

Q4 - A family has established a trust fund for its children, attending college, and has paid $101.514 to a bank. In return, the bak is going to pay the family $20,000 every year for the next 6 years. The first payment will be made 1 year from the day the family paid the bank. What is the interest rate that thic trust fund will be earning?

Answers

The trust fund is earning an interest rate of 5%.

Calculate the the interest rate earned by the trust fund?

To solve for the interest rate earned by the trust fund, we can use the present value formula:

PV = PMT x (1 - 1/(1+r)^n) / r

Where PV is the present value of the payments, PMT is the payment amount, r is the interest rate, and n is the number of payment periods.

In this case, we know that the family paid $101,514 upfront and will receive $20,000 per year for 6 years, with the first payment made 1 year after the initial payment. Therefore, PMT = $20,000, n = 6, and the time period is 5 years.

We can rearrange the formula to solve for r:

r = (PMT / ((PV x r) + PMT)) x (1 - 1/(1+r)^n)

We can start by assuming an interest rate and then use the formula to calculate the present value of the payments. We can then compare this value to the initial payment of $101,514 to see if the assumed interest rate is too high or too low.

Let's assume an interest rate of 4%. Plugging in the values, we get:

PV = $20,000 x (1 - 1/(1+0.04)^6) / 0.04 = $98,619.56

Since $98,619.56 is less than the initial payment of $101,514, we know that the interest rate must be higher than 4%. Let's try an interest rate of 5%:

PV = $20,000 x (1 - 1/(1+0.05)^6) / 0.05 = $101,150.70

Since $101,150.70 is very close to the initial payment of $101,514, we know that the interest rate is approximately 5%. Therefore, the trust fund is earning an interest rate of 5%.

Learn more about trust fund

brainly.com/question/30979602

#SPJ11

economists who study monetary policy believe that it takes anywhere from ________ for monetary policy to have a substantial effect on economic activity.

Answers

Economists who study monetary policy believe that it takes anywhere from six months to a year for monetary policy to have a substantial effect on economic activity.

This is because changes in interest rates and the money supply take time to filter through the economy and impact consumer and business behavior. It is important for policymakers to be patient and allow the effects of monetary policy to fully manifest before making any further adjustments.
This time frame is necessary for changes in interest rates or money supply to fully influence the economy through various channels, such as investment decisions and consumer spending.

Monetary policy is enacted by a central bank to sustain a level economy and keep unemployment low, protect the value of the currency, and maintain economic growth. By manipulating interest rates or reserve requirements, or through open market operations, a central bank affects borrowing, spending, and savings rates.

Learn more about economic activity here: https://brainly.com/question/14545466

#SPJ11

Suppose Omni Consumer Products's CFO is evaluating a project with the following cash inflows. She does not know the project's initial cost; however, she does know that the project's regular payback period is 2.5 years. If the project's weighted average cost of capital (WACC) is 796, what is its NPV? Year Cash Flow Year 1 $275,000 Year 2 $475,000 Year 3 $500,000 Year 4 $450,000 O $486,847 O $359,843 O $423,345 O $465,680 Which of the following statements indicate a disadvantage of using the discounted payback period for capital budgeting decisions? Check all that apply. The discounted payback period does not take the project's entire life into account. The discounted payback period does not take the time value of money into account. The discounted payback period is calculated using net income instead of cash flows.

Answers

The NPV of the project has a payback period of 2.5 years and the weighted average cost of capital (WACC) of 796 is $423,345. The statement indicating the disadvantage of using the discounted payback period for capital budgeting decisions is - The discounted payback period does not take the project's entire life into account.

A capital budgeting technique used to assess a project's profitability is the discounted payback period.

By discounting future cash flows and taking into account the time value of money, a discounted payback period calculates how many years it will take to recover the initial investment.

The metric is employed to assess a project's viability and profitability. The detailed calculation for NPV is attached below.

To learn more on discounted payback period, here:

https://brainly.com/question/27835298

#SPJ12

according to john kotter, leadership a. produces useful change in organizations. b. controls organizational and environmental complexity. c. both agitates for change and advocates stability. d. cannot be distinguished from management.

Answers

According to John Kotter, leadership A. produces a useful change in organizations.

As a renowned expert in organizational change and leadership, Kotter emphasizes the importance of effective leadership in driving transformation and adapting to dynamic environments. Leaders have the vision and ability to inspire, motivate, and guide their teams to achieve desired outcomes. They identify the need for change, set the direction, and work collaboratively with others to bring about meaningful, positive results.

In summary, according to John Kotter, leadership is primarily responsible for producing a useful change in organizations. It plays a crucial role in identifying, initiating, and facilitating transformation. In contrast, management is responsible for controlling complexity and ensuring stability in daily operations. Both leadership and management contribute to the overall success and sustainability of an organization. Therefore the correct option is A

Know more about  John Kotter here:

https://brainly.com/question/1250807

#SPJ11

McMillin Industries is currently 100% equity financed, has 25,000 shares outstanding at a price of $30 a share, and produces an annual EBIT of $150,000. The firm is considering issuing $300,000 of debt and repurchasing shares. The cost of debt is 12%. Ignore taxes. By how much will EPS change if the company issues the debt and EBIT remains constant?
A) $.72 B) $.76 C) $1.72 D) $1.60 E) $1.54

Answers

To calculate the change in EPS, we need to find the earnings available to shareholders after the proposed debt issue and share repurchase.  EPS will decrease by $0.72, Correct answer is option A

Before the debt issue, the company has 25,000 shares outstanding and produces an annual EBIT of $150,000, which means earnings per share (EPS) are: EPS = Earnings / Shares = $150,000 / 25,000 = $6.00

If the company issues $300,000 of debt, the interest expense would be $36,000 ($300,000 x 12%), leaving EBIT of $114,000 ($150,000 - $36,000). The company then repurchases shares with the proceeds of the debt issue, reducing the number of outstanding shares.

Let's assume the company repurchases 10,000 shares at the current market price of $30 per share, leaving 15,000 shares outstanding.The earnings available to shareholders after the debt issue and share repurchase would be:

Earnings = EBIT - Interest expense = $114,000 - $36,000 = $78,000 EPS = Earnings / Shares = $78,000 / 15,000 = $5.28. Therefore, the change in EPS is: Change in EPS = New EPS - Old EPS = $5.28 - $6.00 = -$0.72

So the answer is not among the options provided. The EPS will decrease by $0.72 if the company issues the debt and EBIT remains constant. Correct answer is option A

Know more about debt here:

https://brainly.com/question/31102427

#SPJ11

according to the video, what happens to average tax rates when incomes in the united states rise? multiple choice they decrease. they remain constant. they increase. they can increase or decrease.

Answers

The impact of rising incomes on the average tax rate depends on the structure of the tax system. If tax rates are progressive, the average tax rate will increase as incomes rise, while a proportional or flat tax rate will remain constant.

Explain about how effects on average tax rates when incomes in the united states rise?

The average tax rate is the total amount of taxes paid divided by the total taxable income. When incomes in the United States rise, the average tax rate can increase or decrease, depending on how the tax system is structured.

If tax rates are progressive, meaning they increase as income increases, then the average tax rate will increase as incomes rise. This is because people will be pushed into higher tax brackets as their income increases, resulting in a higher tax rate on their entire income.

On the other hand, if tax rates are proportional or flat, meaning they remain the same regardless of income level, then the average tax rate will remain constant as incomes rise.

Learn more about flat tax rate.

brainly.com/question/894517

#SPJ11

the impact of psychological factors and investor expectations make it difficult for exchange rate theories to predict blank______ changes in exchange rates. multiple choice question.

Answers

The impact of psychological factors and investor expectations make it difficult for exchange rate theories to predict blank changes in exchange rates.

Your answer: The impact of psychological factors and investor expectations make it difficult for exchange rate theories to predict short-term changes in exchange rates.

Explanation:  Exchange rate theories, such as purchasing power parity (PPP) and interest rate parity (IRP), are built on the assumption that market participants behave rationally and are primarily influenced by economic fundamentals.

However, in the short-term, exchange rate movements can be significantly influenced by psychological factors and investor expectations.

Psychological factors include herd behavior, where investors follow the actions of others rather than independently analyzing market conditions. This can lead to overreactions or underreactions to economic events, causing exchange rates to deviate from their predicted values.

Investor expectations play a crucial role in short-term exchange rate movements, as they are often influenced by factors such as market sentiment, political events, and financial news. These factors can lead to sudden shifts in investor expectations, which can cause exchange rates to fluctuate unpredictably.

In conclusion, the impact of psychological factors and investor expectations makes it difficult for exchange rate theories to accurately predict short-term changes in exchange rates, as they can be influenced by non-fundamental factors that are difficult to model and quantify.

To know more about psychological refer here

brainly.com/question/29436774#

#SPJ11

Other Questions
How long does it take for radiation from a cesuim-133 atom to complete 1.5 million cycles the concept of having multiple layers of security policies and practices is known as: cybersecurity culture multifactor authentication defense in depth biometrics true or false once a couple makes a commitment to an intimate relationship is made by a couple, the relationship culture becomes static. What happens when a solid is dissolved into a liquid?. 3. Based on the text, with which statement would the author MOST LIKELY agree?A. DaVinci's inventions were enhanced by his artistic practice.B. DaVinci led an interesting life, even though it was not practical.C. DaVinci ought to be known more as an inventor than as an artist.D. DaVinci rather than the Wright brothers really invented the airplane. Mount Pinatubo ejected large volumes of gas and ash into the atmosphere during its eruption in June 1991. Scientists measured an average global temperature decline of about 2% during the next year. if the average temperature of an area was 25*C prior to the eruption what was the temperature the next year? In the election of 1824, John Quincy Adams was a "Favorite Son" of the Northeastern merchants in the United States. What does it mean to be a "Favorite Son? polaris and the star at the other end of the little dipper, kochab, are both apparent magnitude 2. in a photo of the night sky, they would appear similar to how they appear here in a planetarium simulation: larger than other stars. this is because The effectiveness of magazine advertising is reduced by itsA) inflexibility.B) inability to target specific markets.C) brief life span.D) higher total cost, relative to television advertising. the health care provider orders an oral antibiotic for a male client three times a day for 7 days. the client asks the nurse if this is correct, because his sister took the same antibiotic for 5 days. on what factor is the amount and frequency of the antibiotic dosing based? Find the exact value of sin a, given that cos a=-5/9 and a is in quadrant 3 A bolynomial function has zeros 2, 4, and 6i. What is the minimum degree of thepolynomial function?A. 6B. 5C. 4D. 3 please help me in this question is math,solve just d, e&f The salaries of six bank employees are $37,000, $38,500, $35,000, $37,000, $45,000, $40,000, and $75,000.Which statement is true?Question 1 options:Both the median and mode are appropriate measures of center.The mean, median, and mode are all appropriate measures of center.Both the mean and median are appropriate measures of center.The median is the only appropriate measure of center. Becca is construction triangle d e f using the following angles 50, 65, 65,what mistake did she make? mercury has the widest variation in surface temperatures between night and day of any planet in the solar system. the chordae tendineae attach to the lower surface of cusps of the ______ valve and prevent the valve from flipping into the atrium when the right ventricle is contracting. why did the european renaissance have a more overtly religious cast to it than did the italian renaissance? learning is best defined as a relatively permanent change in behavior. what causes this change? group of answer choices innate knowledge the observation of others only the connection between two stimuli in the environment only experience we must perform dilutions of absorbance values above 1.00 since not enough light is getting through the sample as it is heavily concentrated with solutes question 7 options: true false