Answer:
a. Copy the range of cell D7:D9 then select cell D6 and paste the selection with date format selected. The function will be represented in formula bar with adding +4;365 days.
b. Copy the range of cell D7:D9 then select cell D6 and paste the selection with date format selected. The function will be represented in formula bar with adding -3;365 days.
c. In the formula bar type =365 days; +2 : E6
d. In the formula bar type =365 days ; +2 : C6
Explanation:
Excel is a software which helps the users to easily calculate complex calculation with just one function input. The users can create worksheets using the excel and then link those worksheets with each other. The data can be displayed in the form of table or simple text. It has multiple options to create annual day wise filtered worksheets.
Answer:
Cash flow is the net amount of cash and cash-equivalents being transferred into and out of a business. At the most fundamental level, a company's ability to create value for shareholders is determined by its ability to generate positive cash flows, or more specifically, maximize long-term free cash flow
Explanation:
It may seem that franchise has many benefits since it allows for a person to open and operate a business without much knowledge of how to run a business and generally franchises are well advertised so not much marketing costs are needed, however negative impacts are much more, since you need to pay lifetime percentages for sales and operating under franchise as well as there is no room for creativity and too much dependence on a big business. Also the funds needed to open a franchise are much higher than same business but operating independently. So negative side is prevailing.
Answer:
5.71%
Explanation:
The after tax cost of debt=pretax cost of debt*(1-t)
where t is the tax rate of 35% or 0.35
pretax cost of debt=yield to maturity
The yield to maturity can be determined using rate formula in excel as below:
=rate(nper,pmt,-pv,fv)
nper is the number of coupon interest payable by the bonds i.e 12 coupons in 12 years
pmt is the annual coupon=$1000*9.5%=$95
pv is the current market price-flotation cost=$1,100-$48=$1052
fv is the face value of $1000
=rate(12,95,-1052,1000)=8.78%
After tax cost of debt=8.78%
*(1-0.35)=5.71%
